Ranking Formula Problem

JERRY89
4StarLounger
Posts: 516
Joined: 21 Feb 2016, 02:52

Ranking Formula Problem

Post by JERRY89 »

Dear All,

Is there any possibility to perform ranking based on CRITERIA. Currently i am using this formula =RANK.EQ($I2,$I$2:$I$154,1) but the problem is it rank the whole list so is there a possibility i can add in another criteria where ranking can based on a GROUP OF DATA in the LIST..My COLUMN B have a few grouping, in this case anyone have any idea to have add this GROUPING in COLUMN B in the formula.

User avatar
HansV
Administrator
Posts: 78229
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Ranking Formula Problem

Post by HansV »

Best wishes,
Hans

JERRY89
4StarLounger
Posts: 516
Joined: 21 Feb 2016, 02:52

Re: Ranking Formula Problem

Post by JERRY89 »

Hi Hans,

This formula is look good COUNTIFS($B$2:$CB154,C2,$F$2:$F$154,">"&F2)+1 , but can it rank based on Ascending Order.

User avatar
HansV
Administrator
Posts: 78229
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Ranking Formula Problem

Post by HansV »

As the article says, change ">" to "<".
Best wishes,
Hans

JERRY89
4StarLounger
Posts: 516
Joined: 21 Feb 2016, 02:52

Re: Ranking Formula Problem

Post by JERRY89 »

Hi Hans,

Thanks a lot...sorry for trouble you. :cheers: