| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Which column in an array of columns
Dear Experts,
What is the formula that would return the current column index within an array of columns? I appologize if my terms are incorrect. Example: In an array or range of columns from C:F, the formula in column D would = 2, Column F = 4. Thanks. DK |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Which column in an array of columns
=COLUMN()-COLUMN($C$1)+1
HTH, Bernie MS Excel MVP "DK" wrote in message ... Dear Experts, What is the formula that would return the current column index within an array of columns? I appologize if my terms are incorrect. Example: In an array or range of columns from C:F, the formula in column D would = 2, Column F = 4. Thanks. DK |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Which column in an array of columns
Thanks Bernie,
I see that I only need to identify the starting column and not the range of columns. Thanks again. DK "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... =COLUMN()-COLUMN($C$1)+1 HTH, Bernie MS Excel MVP "DK" wrote in message ... Dear Experts, What is the formula that would return the current column index within an array of columns? I appologize if my terms are incorrect. Example: In an array or range of columns from C:F, the formula in column D would = 2, Column F = 4. Thanks. DK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I name rows and columns in an array | New Users to Excel | |||
| How to manipulate an 2D Array into a Column Array? | Excel Discussion (Misc queries) | |||
| Finding a number in a column out of an array in another column | Excel Discussion (Misc queries) | |||
| Array? Put values from random columns into 4 | Excel Worksheet Functions | |||
| UDF to sort array with multiple columns | Excel Worksheet Functions | |||
Hybrid Mode
