Rankif Function

Hi everyone,

I'm looking for a bit of help on a Rankif function to help me see how products rank within their respective sub-categories. I have a large list of products in a worksheet each with a unique identifier (Column A) and Sub-Category (Column D). There are then a number of scoring criteria which create a Overall Popularity Score (Column AZ). This score is then used to rank the products in Column BA. Note I have written this Rank function to ensure that if two or more products get the same score then they are given sequential ranking so no product gets the same ranking. So far no problem.

However, I'd like to now rank these products in terms of their Overall Popularity Score (Column AZ) within their Sub-Category; if two or more products in a sub-category score the same then again I would like their ranking to be sequential. I'd like to have a column for each Sub-Category (Columns BB2 to BL2 which define the sub-category name) which shows the product ranking within it's sub-category. By having these 11 columns it will enable me to create a dashboard for each Sub-Category so I can have dynamic and visual products for each.

Does this make sense? Can anyone help me out?

Thanks

Nick

As requested, here's an example with the desired outcomes shown in yellow.

Thanks FDibbins, greatly appreciated

Shamelessly bumped up the thread....I need help!

Try this in J2:

=IF(RIGHT(J$1,LEN($C2))=$C2,COUNTIFS($C$2:$C$10,$C2,$H$2:$H$10,">"&$H2)+COUNTIFS($C$2:$C2,$C2,$H$2:$H2,$H2),"")

Copy acroos and down.

Phuocam.....YOU ARE A GENIUS!!!! This works perfectly, kudos to you,kudos indeed

Originally Posted by Phuocam

Try this in J2:

=IF(RIGHT(J$1,LEN($C2))=$C2,COUNTIFS($C$2:$C$10,$C2,$H$2:$H$10,">"&$H2)+COUNTIFS($C$2:$C2,$C2,$H$2:$H2,$H2),"")

Copy acroos and down.

Sorry, will be less impatient next time.....the people here are so helpful and geniuses!

No worries dude, life happens! Not to worry, got a fine solution to my problem.

Originally Posted by FDibbins

My apologies, real life interfered again