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!
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!