min of max....

[johnT]

i have two rows of numbers....i want to find the minimum
value in the second row only of the columns that contain
the maximum value in the top row???

 

[KL]

Hi there,

Try this array formula (Ctrl+Shift+Enter):

=MIN(IF(A1:K1=MAX(A1:K1),A2:K2))

Regards,
KL

 

[johnT]

yes, that works, thanks alot

-----Original Message-----
Hi there,

Try this array formula (Ctrl+Shift+Enter):

=MIN(IF(A1:K1=MAX(A1:K1),A2:K2))

Regards,
KL




.