williamsripa
New Member
- Joined
- Dec 2, 2005
- Messages
- 3
I want to rank a group of numbers (from formulas in other cells) using the rank function, but when it encounters a 0 it displays it as #N/A and throws off the entire list.
I need these 0's to display in the right order in the list... obviously 0 is a lower number than 1 and should be ranked first at the top in ascending order!
The numbers that it's trying to rank all come from formulas that take one cell and divide it by another, and there are often 0's in these cells also, but I can use the IF function to force it to display "0" in those cases.
Is there an option that will make it rank zeroes properly? the exact function in the formula bar I'm using is something like:
=RANK(G23,G3:G29,1)
even if i use absolute values it still doesnt work.
=RANK(G23,$G$3:$G:$29,1)
I wish i could just tell it that 0 divided by 0 is 0. =/
I need these 0's to display in the right order in the list... obviously 0 is a lower number than 1 and should be ranked first at the top in ascending order!
The numbers that it's trying to rank all come from formulas that take one cell and divide it by another, and there are often 0's in these cells also, but I can use the IF function to force it to display "0" in those cases.
Is there an option that will make it rank zeroes properly? the exact function in the formula bar I'm using is something like:
=RANK(G23,G3:G29,1)
even if i use absolute values it still doesnt work.
=RANK(G23,$G$3:$G:$29,1)
I wish i could just tell it that 0 divided by 0 is 0. =/