If the minimum can also occur in A2:E2 you will get a wrong cell

address.

In this case you better do the MATCH into the range for minimum:

=MIN(F2:H2)&" in "&ADDRESS(ROW(F2),MATCH(MIN(F2:H2),F2:H2,0)+COLUMN (F2)-1,4)



The formula is more versatile. You also can copy down the formula.





Regards

Claus B.

--


I can't make that error occur with the first formula.

With 1 to 8 in A - H both seem to work fine, each returns "6 in F2".

I'll go with the latter on your advice anyway.

Thanks again.
Howard