Identifying the largest value Max() based on a list generated using Countifs()

[Eric D.]

Hello,

Not sure how descriptive the title above is but attached is a description of what I'm trying to achieve. The tables are not showing correctly here.

Hope to hear from you soon and thanks in advance.

Cheers,
Eric

 

[Somendra Misra]

Hi Eric,

Welcome to the forum.

When it comes to Excel it's always better to upload a sample Excel File. Kindly, do so.

Regards,

 

[Eric D.]

Hi Somendra,

Thanks. Fiind attached a version of the file that will allow me to attach here (original file is 2MB).

Cheers,
Eric

 

[Hui]

Can you put some notes about which data fields correspond to which columns in the report?