OK, yes, instead of the scores you could just use the ranks, perhaps that would be simpler, i.e. this version in D4
=COUNTIF(C$4:C$19,">"&C4)+(COUNTIF(C$4:C$19,C4)+1)/2
OK, yes, instead of the scores you could just use the ranks, perhaps that would be simpler, i.e. this version in D4
=COUNTIF(C$4:C$19,">"&C4)+(COUNTIF(C$4:C$19,C4)+1)/2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks