Rank Tie
If you are looking for the correction factor from the Excel help entry for
the RANK function, then I guess you intended to use
=COUNT(B$69:B$77)+1-RANK(B69,B$69:B$77,)-RANK(B69,B$69:B$77,1)/2 ?
--
David Biddulph
"RaY" wrote in message
...
My formula keeps returning 1 for every value on the rank list. I'm not
sure
what i'm missing. I need it to rank the ties but not skip any rankings.
=COUNT(B69:B77+1-RANK(B69,B69:B77,)-RANK(B69,B69:B77,1)/2)
Rank Military Time
A B
1200
1530
1830
1200
1330
1730
1330
|