Forum Discussion
Finding a Unique Rank based on Drop Down Lists
Hi everyone, I'm in a bit of a pickle and was hoping to get some help. I am working on a project where I am trying to find the unique rank of something based on its score depending on a chang...
In B10:
=INDEX($A$3:$A$6,MATCH($A10,INDEX($J$3:$M$6,,MATCH($A$9,$J$2:$M$2,0)),0))In B16:
=INDEX($A$3:$A$6,MATCH($A10,INDEX($J$3:$M$6,,MATCH($A$15,$J$2:$M$2,0)),0))See the attached version.
