After entering the formula with CTRL+SHIFT+ENTER, I get "#N/A" in the cell. :(



"David Billigmeier" wrote:

Are you entering the formula with CTRL+SHIFT+ENTER (NOT by just pressing
ENTER)?

--
Regards,
Dave
<!--


"Red 61" wrote:

Thanks David -- however, I'm getting an error in the formula which says, "A
value used in the formula is of the wrong data type." The error is in the
B1:B10 section of the formula, below. :(


"David Billigmeier" wrote:

Assume your salesperson names are in column B and their corresponding sale
amount is in column C:

=MAX(IF(B1:B10="Bob",C1:C10,""))
=MIN(IF(B1:B10="Bob",C1:C10,""))

These are array formulas so confirm with CTRL+SHIFT+ENTER. Also change the
row/column numbers to fit your data.


--
Regards,
Dave
<!--


"Red 61" wrote:

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?