MIN IF?
=MIN(IF(A$1:A$3=A1,B$1:B$3)) as an *array formula*, and copy down.
--
David Biddulph
wrote in message
oups.com...
I have a table with two columns:
Col_1 Col_2
XXX-YYY 123
XXX-YYY 120
YYY-QQQ 143
I want to find the minimum in col_2 for each entry in Col_1.
I have done it using a pivot table but would like to be more flexible.
Is there a way of nesting the MIN and an IF statement?
Steve
|