MIN value based on 2 criteria

[theta]

Hi guys, been playing round with arrays and SUMPRODUCT for a while but can't quite get this right

I have repeated pairs in column A and B, and they each have a value in column E.

I need to find the minimum value in column E for each given pair...ideas?

(A2:A1600=A2) and (B2:B1600=B2) then MIN of (E2:E1600)

Will then copy this formula down for all 1600 rows to get the MIN of each pair

 

[MrVillareal]

Hi,

Can you post sample data..

 

[theta]

GHJKL.....IKLMK.....45869.....45869 (desired formula result)
GHJKL.....IKLMK.....45983.....45869 (desired formula result)
GHJKL.....IKLMK.....89562.....45869 (desired formula result)
IKLIO.....JUFKI.....85693.....23456 (desired formula result)
IKLIO.....JUFKI.....56231.....23456 (desired formula result)
IKLIO.....JUFKI.....23456.....23456 (desired formula result)

 

[MikeWx]

Assuming your first value is in A2, the following array formula in D2 will work:

=MIN(IF(A2=$A$2:$A$7,IF(B2=$B$2:$B$7,$C$2:$C$7)))

 

[theta]

I was using the ,0 extension in the IF... ooops