Column Numbers

[Doug Terry]

How do I get the column number of the minimum value in a row?
Example:
A B C D
4 9 2.5 7

How do I get the column number of 3? I'd like to use this value in a lookup
function in another location.

Thanks,

 

[Mike H]

Hi,

=MATCH(MIN(A11),A11,0)

Mike

 

[Niek Otten]

Hi Doug,

=MATCH(MIN(A11),A11,0)

 

[Sheeloo]

Try this in A2

=LOOKUP(2,1/(A11=MIN(A11)),COLUMN(1:1))

Change D, in D1 in the formula, to the column letter if you want to extend
the range...

 

[Doug Terry]

Thanks very much everyone. This answers my question and will greatly
simplify finding things in a large spreadsheet)