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.
Ranking Formula Problem
-
- Administrator
- Posts: 78595
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 4StarLounger
- Posts: 516
- Joined: 21 Feb 2016, 02:52
Re: Ranking Formula Problem
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.
This formula is look good COUNTIFS($B$2:$CB154,C2,$F$2:$F$154,">"&F2)+1 , but can it rank based on Ascending Order.
-
- Administrator
- Posts: 78595
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 4StarLounger
- Posts: 516
- Joined: 21 Feb 2016, 02:52
Re: Ranking Formula Problem
Hi Hans,
Thanks a lot...sorry for trouble you.
Thanks a lot...sorry for trouble you.