Hello everyone,
I'm trying to create a formula that provides the rank of each cell from the lowest value to the highest without any duplicate ranks and ignores zeros.
Example:
I appreciate any help.
I'm trying to create a formula that provides the rank of each cell from the lowest value to the highest without any duplicate ranks and ignores zeros.
Example:
Values | Rank |
5 | 6 |
5 | 5 |
4 | 4 |
2 | 3 |
1 | 2 |
0 | |
1 | 1 |
0 |
I appreciate any help.