Hi, I've seen some posts on this topic but none seems to work for me.
I need to rank some numbers in corresponding groups.
NAME REG Attendence rank
A AB 98
B Ac 97
C AC 96
D AC 99
E AB 100
F AB 100
I would expect that for group AB the ranking would be: E=3 points F= 3 points A = 1 point
and for group AC: D=3 points, C= 2 points, B= 1 point
I tried
=IF(E2=E2,COUNTIFS($E$2:$E$1600,E2,$FD$2:$FD$1600,"="&FD2)+1,"") (column E is group and column FD is attendance, but the results are not as expected
Any help is appreciated.
Thank you
Bookmarks