Displaying data based on ranking with validation

[ajinkya deshmukh]

Hello,

Please refer the attached excel file for data. I need help as below

1. In sheet "Category Summary" when we filter on Cell C4 for the category the values should populate in the table based on the rank as per the Category. (as an example I have shown for product A)

2. In Sheet "Data" the rank formula displays the ranking as per the Score. I would like to have the ranking based on Product and score. For eg: When we filter on Product A the ranking should be 1, 2, 3 etc. This data then should be displayed in Sheet "Category Summary" as per the validation in cell C4.

 

[Somendra Misra]

Hi,

See your file, the formula currently not dealing with duplicate scores for the same category.

Regards,

 

[ajinkya deshmukh]

Thank You Somendra, This helps us a lot. Btw, is there a way to deal with duplicates scores??

 

[Somendra Misra]

Do want to assign same rank for duplicate or different?

Regards,

 

[ajinkya deshmukh]

Hi we want to assign different ranks for duplicates.

 

[Somendra Misra]

@ajinkya deshmukh

Sorry I was away for two days, was on an Offical tour. Will write back may be by tomorrow's evening, now flying back.

Regards,