Excel Guru's!!!!!

[Psychoe]

If I had 20 or so people in a sports pool with weekly points, what funtion would I use to sort them out in order from 1 - 20?

How would I use this function?

The only way I know of is this:

A1=50 B1=Frank
A2=45 B2=Bob

=IF(A1>A2,B1,B2)

this would print "Frank"

Only problem is this only compares 2, not 20 or more.

Thanks

E!

 

[Cromewell]

use VBA code (macro) with a loop to go through each row with data in it, it will be much easier than trying to generate a massive excel if

 

[Psychoe]

Do u (or anyone) know of any tutorials on macro's? I have never done one so the easiest and most specific tutorial is needed.


Thx

E!

 

[Trizoy]

Data > sort