| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Numbers
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column Numbers
Hi,
=MATCH(MIN(A1:D1),A1:D1,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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column Numbers
Hi Doug,
=MATCH(MIN(A1:D1),A1:D1,0) -- Kind regards, Niek Otten Microsoft MVP - Excel "Doug Terry" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column Numbers
Try this in A2
=LOOKUP(2,1/(A1:D1=MIN(A1:D1)),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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column Numbers
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
| Can I change a column of calculated numbers to absolute numbers? | Excel Discussion (Misc queries) | |||
| Match Column B numbers to Column A numbers | Excel Worksheet Functions | |||
| Changing column of numbers made of formulas to just numbers | Excel Discussion (Misc queries) | |||
| Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions | |||
Linear Mode
