Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a function to get column # of cell with matching value
Hi,
I would like to write a function that will bring out the column index number for a cell containg a particulat lot #, i.e. A B C 1 3 366 5 2 22 What function do I need to use that will determine the column index # for the cell containing the value of "366"?? Thanks, Neslihan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a function to get column # of cell with matching value
Try this array formula** :
=MAX((A1:C2=366)*COLUMN(A1:C2)) If there are multiple instances of 366 the formula will return the rightmost column number. ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) -- Biff Microsoft Excel MVP "Neslihan" wrote in message ... Hi, I would like to write a function that will bring out the column index number for a cell containg a particulat lot #, i.e. A B C 1 3 366 5 2 22 What function do I need to use that will determine the column index # for the cell containing the value of "366"?? Thanks, Neslihan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching down a column | Excel Worksheet Functions | |||
matching from one column to another | Excel Discussion (Misc queries) | |||
matching from one column to another | Excel Discussion (Misc queries) | |||
find a cell matching separate column and row values | Excel Worksheet Functions | |||
Matching data and linking it to the matching cell | Links and Linking in Excel |