MIN on rows instead of columns?

[samilynn]

I know how to use MIN to get the lowest value in multiple columns.
Is there a way to get the lowest value from multiple rows?

Example:
Col A Col B

Prod A 1.25
Prod A 1.20
Prod A 1.19
Prod B 5.49
Prod B 5.00

In this example, I would want to extract 1.19 for Prod A, and 5.00 for Prod B.

Thanks in advance!!

Samantha

 

[Scott Huish]

If you have a lot of them you may want to look at Pivot Tables, but formula wise:

=MIN(IF(A1:A5="Prod A",B1:B5))

Confirm with CTRL-SHIFT-ENTER rather than just Enter.