how to access data on the same row?

  • Thread starter Thread starter Vanil
  • Start date Start date
V

Vanil

Heya..

Okay, the problem basically is that in column A there's a bunch of
names, in column B there's a bunch of numbers/scores... now the
question is: how to find out who has the highest score and who has the
lowest?

With the min() and max() I can get the scores sure, but I don't know
how to get the name that I need tagged along with that score.

Any suggestions?

Thanks.
 
Vanil,

=OFFSET(A1,MATCH(MAX(B:B),B:B)-1,0)
=OFFSET(A1,MATCH(MIN(B:B),B:B)-1,0)

HTH,
Bernie
 
Back
Top