I am trying to figure out how to use the rank function on a column of
data. The trick is that i dont want it to include or rank zero's. To
achieve a ranking the number should be a positive number. Here is what
i have so far.
For instance if i had a column that was
32
0
14
55
14 would have a rank of 1, etc.
I dont care if it duplicates a ranking as long as the numbers are
EXACTLY the same. like two items can be ranked 5 if they are both
$6.06
=RANK(I5,$I5:$I40,1)&" of "&COUNTIF($I$5:$I$40, ">0")
data. The trick is that i dont want it to include or rank zero's. To
achieve a ranking the number should be a positive number. Here is what
i have so far.
For instance if i had a column that was
32
0
14
55
14 would have a rank of 1, etc.
I dont care if it duplicates a ranking as long as the numbers are
EXACTLY the same. like two items can be ranked 5 if they are both
$6.06
=RANK(I5,$I5:$I40,1)&" of "&COUNTIF($I$5:$I$40, ">0")