min of max....

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???

Hi there,

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

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

Regards,
KL

"johnT" <anonymous@discussions.microsoft.com> wrote in message
news:1c0901c52d6f$2eabd4c0$a401280a@phx.gbl...
>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???

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
>
>"johnT" <anonymous@discussions.microsoft.com> wrote in
message
>news:1c0901c52d6f$2eabd4c0$a401280a@phx.gbl...
>>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???
>
>
>.
>