How can I change the default "low" rank used to break ties in percent ranks?
Can it be set to medium or high?
How can I change the default "low" rank used to break ties in percent ranks?
Can it be set to medium or high?
Do you mean...
If this is a sample:
1
2
2
4
With Rank the order will be --> 4,2,2,1
And with CountIf...
Countif: =COUNTIF($A$1:$A$4,">"&A1)+1 --> 4,2,2,1
Countif: =COUNTIF($A$1:$A$4,">"&A1)+1+COUNTIF($A$1:$A$4,A1)-1 --> 4,3,3,1
HTH
Ola Sandström
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks