Hey guys,
I am trying to values from lowest to highest. I want to ignore zeros and also the values can be negative. I am stuck and using the rank function does not work.
For example:
A: -3
B: -1
C: 0
D: 1
E: -5
F: 0
The rankings would then list E -> 1, A -> 2, B->3, D -> 4
Help would be appreciated thanks. Sample excel attached
Bookmarks