Column B = Names
Column K = A calculated %
Column V = Ranked (column K) from high to low
Previous Array formula that now returns errors due to the latest update. It used to display the name associated with the ranked % in column V
Column U = INDEX($B$10:$B$51,SMALL(IF($K$10:$K$51=V10,ROW($K$10:$K$51)-ROW($K$9)),COUNTIF($V10:V$10,V10)))
I am no expert and have no idea how to fix this. Someone helped me with the array formula I previously had working.
Hoping someone can look at it, and somehow manage to tell me what I need to do to get it to work once again.
Thank you in advance.
Test.ods (40.9 KB)