Mac Forum / Applications / Excel / May 2008

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

I am trying to rank a series of numbers and have set the formulas to deal with up to 4 ties, but would like to handle up to 10 ties. The formula I am currently using is fairly complex because I am also only looking at cells that have an entry, I would like to find a more simple method of ranking and would appreciate any help I can get. The current formula I am using is below:

=IF(B10="","",IF(ISERROR(MATCH(RANK(N10,N7:N54,0),P7:P9,0)),RANK(N10,N7:N54,0),IF(ISERROR(MATCH(RANK(N10,N7:N54,0)+0.01,P7:P9,0)),RANK(N10,N7:N54,0)+0.01,IF(ISERROR(MATCH(RANK(N10,N7:N54,0)+0.02,P7:P9,0)),RANK(N10,N7:N54,0)+0.02,RANK(N10,N7:N54,0)+0.03))))

This is the 4th cell in a column of up to 54 cells.

Thanks for any help available.