| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column function
I want to use the column function to determine the column number of a cell
reference at another cell location. That is to say, cell F5 has the value of another reference CZ108. Can some one help me with an expression to determine this. Sajit |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Column function
=COLUMN(INDIRECT(F5))
where cell F5 has the text CZ108. "Sajit" wrote: I want to use the column function to determine the column number of a cell reference at another cell location. That is to say, cell F5 has the value of another reference CZ108. Can some one help me with an expression to determine this. Sajit |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Column function
I want use minus function in text function.for e.g. 8:10 - 8:30 .can use it
this? "Sajit" wrote: I want to use the column function to determine the column number of a cell reference at another cell location. That is to say, cell F5 has the value of another reference CZ108. Can some one help me with an expression to determine this. Sajit |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Column function
Thanks Vergel, exactly what I was looking for.
"Vergel Adriano" wrote: =COLUMN(INDIRECT(F5)) where cell F5 has the text CZ108. "Sajit" wrote: I want to use the column function to determine the column number of a cell reference at another cell location. That is to say, cell F5 has the value of another reference CZ108. Can some one help me with an expression to determine this. Sajit |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inverse of the column function? i.e. input a number, output thecorresponding column text label | Excel Worksheet Functions | |||
| LookUp Function with Two Column Search Returning One Column Value | Excel Worksheet Functions | |||
| Set whole column with function | Excel Discussion (Misc queries) | |||
| How to replace column letter in refferences with a function using the old column letter? | Links and Linking in Excel | |||
| How to replace column letter in refferences with a function using the old column letter? | Excel Worksheet Functions | |||
Linear Mode
