Simple Excel question

Originally Posted by rohan076

I have 3 columns and 2 rows

10 23 05
A B C


The 4th Column should print the min of (10, 23, 05) and the cell below should print the corresponding alphabet.

The the above example, the 4th column should have

05
C

Please can someone help me with this??

One small point, why is the number 5 preceded by a 0. is this some special formatting?

The two formulae are:

Please Login or Register  to view this content.

HTH

This should do the trick for you.

D1 = "=MIN(A1:C1)"
D2 = "=HLOOKUP(D1,A1:C2,2,FALSE)"

Hope that helps.

Thanks Guys, that worked.