how to access data on the same row?

[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.

 

[Bernie Deitrick]

Vanil,

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

HTH,
Bernie

 

[Vanil]

Thanks alot Bernie!