B C D E F G
Jack $156.00 Jack $157.04 Jack $99.12
Joe $131.28 Joe $150.79 Joe $92.56
Mary $128.93 Mary $128.94 Mary $66.06
Mark $124.00 Mark $101.31 Mark $52.43
I need to rank the data in columns c,e,g and return the answer in column a next to Jack, Joe, Mary and so on. Here is an example of the formula that is not working for me, =rank(C2,C2:C5,F2:F5,I2:I5,0), it returns to tell me I have used to many instances. Thanks for the help.
Jack $156.00 Jack $157.04 Jack $99.12
Joe $131.28 Joe $150.79 Joe $92.56
Mary $128.93 Mary $128.94 Mary $66.06
Mark $124.00 Mark $101.31 Mark $52.43
I need to rank the data in columns c,e,g and return the answer in column a next to Jack, Joe, Mary and so on. Here is an example of the formula that is not working for me, =rank(C2,C2:C5,F2:F5,I2:I5,0), it returns to tell me I have used to many instances. Thanks for the help.