"carolruth11" wrote:
I believe that using the functions MIN and MAX would be the best way
to do this, but I am unsure!

Probably correct.

There is a small chance that you might need to use SUBTOTAL, for example if
you use a filter. If you don't know what that is, you probably do not need
to worry about using SUBTOTAL.

If you post some details about the design of the worksheet, we might be able
to provide more specific guidance.


It is for a homework assignment and it is due by Sunday night.

That's 3 days from now. I think you have time to read the Help pages for
MIN and MAX. Just click on Help.


----- original message -----

"carolruth11" wrote in message
...
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