G
Guest
I am trying to rank in ascending order a list of numbers where some of the
cells have 0 values. I would like the 0 values to be ignored and not ranked.
Is this possible?
Example:
Col C The ranking I would like:
4813.29 3
7025.59 2
0 [cell would be blank]
0 [cell would be blank]
8287.85 1
cells have 0 values. I would like the 0 values to be ignored and not ranked.
Is this possible?
Example:
Col C The ranking I would like:
4813.29 3
7025.59 2
0 [cell would be blank]
0 [cell would be blank]
8287.85 1