Experts:
I need some assistance with developing a formula that mimics/re-ranks priorities following the "Olympic Medal" award process. Please see attached sample XLS which includes all details and background in a callout.
Thank you for your help in advance,
EEH
Please try at E2
=RANK(C2,INDEX($C$2:$C$33,MATCH(B2,$B$2:$B$33,)):INDEX($C$2:$C$33,MATCH(2,1/($B$2:$B$33=B2))),-1)
Bo_Ry -- wow... another perfect solution! Output is exactly what I was looking for. 1000 thanks!
Bo_Ry:
Good morning... I posted a different (but related) question in support of the same project. Any thoughts on it?
https://www.excelforum.com/excel-for...ml#post5345238
Last edited by skydivetom; 06-07-2020 at 07:44 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks