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,
--
Doug Terry

Hi,

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

Mike

"Doug Terry" wrote:

> 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,
> --
> Doug Terry

Hi Doug,

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Doug Terry" <(E-Mail Removed)> wrote in message
news:C7635392-3AF8-4043-8867-(E-Mail Removed)...
> 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,
> --
> Doug Terry

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" wrote:

> 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,
> --
> Doug Terry

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


"Doug Terry" wrote:

> 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,
> --
> Doug Terry