kind of new to excel, need help finding values

[evann]

worked great, thanks.

now to another question..say I want to rank these guys. How can I fin
#1,#2,#3 etc?

thanks man, and incase you are wondering they are online game stats

 

[RagDyer]

You can add a column to your stats, say Column H.
In H1 enter this:

=RANK(B1,$B$1:$B$100)

And drag down to copy as needed.
This formula gives the *highest* number the rank of 1.
If you were looking for the *lowest* number to rank as 1, such as in golf,
try this formula:

=RANK(B1,$B$1:$B$100,1)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================





worked great, thanks.

now to another question..say I want to rank these guys. How can I find
#1,#2,#3 etc?

thanks man, and incase you are wondering they are online game stats.

 

[Domenic]

worked great, thanks.

now to another question..say I want to rank these guys. How can I fin
#1,#2,#3 etc?

thanks man, and incase you are wondering they are online game stats.

In case of ties, you can use the following formula...

H2, copied down:

=RANK(B2,$B$2:$B$10)+COUNTIF($B$2:B2,B2)-1

Hope this helps

 

[Frank Kabel]

Hi
also see:
http://www.xldynamic.com/source/xld.RANK.html