COUNTIFS as Rank

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

CodeFunctionName
What is this?

Public

Tested

Original Work
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

Views 82

Downloads 35

CodeID
DB ID

ANmarAmdeen
602
Attachments
Revisions

v1.0

Saturday
January
1
2022