Simplest way to rank among peers. used COUNTIFS in case we need to add more conditions because is never that simple, right
Or, you can do the more complicated version here
This is more like a ready to use formula inside Excel, I needed to put it here to see if other solutions are void.
Add another column to find the rank, having ....
Rank by column FL, with same value found in E in ascending order (larger is better)
=COUNTIFS( $E:$E, $E2, FL:FL, " >" & FL2) + 1
Same rank but with reverse order (Smaller is better).
=COUNTIFS( $E:$E, $E2, FL:FL, " <" & FL2) + 1
Add another column to find the rank, having ....
Rank by column FL, with same value found in E in ascending order (larger is better)
=COUNTIFS( $E:$E, $E2, FL:FL, " >" & FL2) + 1
Same rank but with reverse order (Smaller is better).
=COUNTIFS( $E:$E, $E2, FL:FL, " <" & FL2) + 1
Views 82
Downloads 35
CodeID
DB ID