Say your names are in A2:A99 and your amounts are in B2:B99.

=max(b2:b99)
will show the largest amount in b2:b99

=min(b2:b99)
will show the smallest amount in b2:b99

To get the name of the first matching amount (lowest number row) with the
highest amount:

=index(a2:a99,match(max(b2:b99),b2:b99,0))

Change max to min to get the name of the first matching amount with the lowest
amount:

=index(a2:a99,match(min(b2:b99),b2:b99,0))

But the bad news is that if there are ties for either the min or max, these
formulas will always return the name in the lower numbered row (closest to the
top of the data).


ps.

=large(b2:b99,7)
will get the 7th largest amount.

=small(b2:b99,12)
will get the 12 smallest amount



carolruth11 wrote:

Hi, I am a new user. I am trying to write a report and trying to figure out
who is the highest salesperson and who is the lowest salesperson within this
report. I believe that using the functions MIN and MAX would be the best way
to do this, but I am unsure! Could someone help me PLEASE? I cannot figure
it out. It is for a homework assignment and it is due by Sunday night.

I really appreciate any and all help!
Carol

--

Dave Peterson