Help with Array formula??

[Guest]

I have data that looks like this in Cols Y and Z

DS 34,680.00
AA I 12,271.68
AA I 25,656.00
AA II 32,064.00
AA II 31,824.00
AA II 34,560.00
AA II 31,824.00
AA II 32,844.00
AA II 31,236.00
AA II 24,984.00
AA II 33,780.00
AA III 40,692.00
AA III 31,416.00
AA III 34,332.00
AA III 41,796.00
AA III 38,436.00
AA III 33,660.00
AA III 37,092.00
AA III 39,156.00
PA I 38,205.48
PA I 44,208.00
PA I 43,752.00
PA I 39,720.00
PA II 44,232.00
LA I 36,315.96

In Col A I've created a list of unique values from Col Y.
In Col B I've got the count of each unique value (eg, 2
instances of AA II).
In Col C I've got an average salary (using sumif).
I also want to find the min and max for each unique
value in Col A but I can't figure out how to return
the range and then apply min or max.

What's the easiest way to do this?

Tx,
gary

 

[Biff]

Hi!

If the value in A1 is AA 1:

MIN(IF(Y1:Y500=A1,Z1:Z500))
MAX(IF(Y1:Y500=A1,Z1:Z500))

Entered as an array - CTRL,SHIFT,ENTER

Biff