I am using the ranking function and have noticed that in cases where I have 2 or more numbers with the same value, they are ranked the same but the next rank is missing. See the photo for what I mean. The rank #4 and #6 are missing. Is there a way to make sure that ranking numbers are not skipped?
iMac 24", Mac OS X (10.6.3), Macbook Pro, Epson Pro 3880, NIK, Photoshop, Nikon D300, Spyder3
Are you trying to break ties? If so one way is to add an index column and base your RANK function on that, e.g.
=B+ROW()/9999999
This will add a very small number based on the row the value is in, thus making your second 82 on row 8 slightly larger than 82 on row 7.
Then base your RANK function on the new index column.
SG
No, ties are fine to have. I need a way to allow ties and still carry on with the sequence without skipping numbers.
rank function missing some ranking numbers
