M
mrvica
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),P79,0)),RANK(N10,N7:N54,0),IF(ISERROR(MATCH(RANK(N10,N7:N54,0)+0.01,P79,0)),RANK(N10,N7:N54,0)+0.01,IF(ISERROR(MATCH(RANK(N10,N7:N54,0)+0.02,P79,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.
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),P79,0)),RANK(N10,N7:N54,0),IF(ISERROR(MATCH(RANK(N10,N7:N54,0)+0.01,P79,0)),RANK(N10,N7:N54,0)+0.01,IF(ISERROR(MATCH(RANK(N10,N7:N54,0)+0.02,P79,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.