H H4Fi Nov 9, 2004 #1 I need a formula that puts a ranking next to the person with the most points going from 1st to 10th e.g 24 - 3rd 23 - 2nd 54 - 1st
I need a formula that puts a ranking next to the person with the most points going from 1st to 10th e.g 24 - 3rd 23 - 2nd 54 - 1st
J JE McGimpsey Nov 9, 2004 #2 One way: B1: =IF(RANK(A1,A:A)<=10,RANK(A1,A:A),"") Copy down as far as necessary.
B BenjieLop Nov 9, 2004 #3 H4Fi said: I need a formula that puts a ranking next to the person with the most points going from 1st to 10th e.g 24 - 3rd 23 - 2nd 54 - 1st Click to expand... Check these out ... http://www.xldynamic.com/source/xld.RANK.html http://www.cpearson.com/excel/rank.htm
H4Fi said: I need a formula that puts a ranking next to the person with the most points going from 1st to 10th e.g 24 - 3rd 23 - 2nd 54 - 1st Click to expand... Check these out ... http://www.xldynamic.com/source/xld.RANK.html http://www.cpearson.com/excel/rank.htm
