Hi there,

I am trying to find the minimum and maximum sales for each salesperson. I
can not sort by salesperson -- I must sort by sales date. How do I do this?

1/2/1999 Bob $7
1/5/1999 Rick $20
1/7/1999 Sue $75
1/10/1999 Bob $5
1/15/1999 Sue $3
1/27/1999 Rick $53

So, I need to know Bob's minimum sale was $5, and his maximum sale was $7.

I know how to use the MIN and MAX functions, but how do I tie in the sales
person name?