| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Obscure Function
I used to use a function where a formula would look in a cell to find what
column or row it should use in the formula. Anyone know what this is callled? Thanks, KW_Counter |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Obscure Function
Stabbing around somewhat blindly...
INDIRECT() - uses the value in the referenced cell as an address. ROW() returns the row of the referenced cell COLUMN() returns the column of the referenced cell where "referenced cell" is the cell address within the () of those functions. "KW_Counter" wrote: I used to use a function where a formula would look in a cell to find what column or row it should use in the formula. Anyone know what this is callled? Thanks, KW_Counter |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Obscure Function
Also, Index() and Offset()
"JLatham" wrote: Stabbing around somewhat blindly... INDIRECT() - uses the value in the referenced cell as an address. ROW() returns the row of the referenced cell COLUMN() returns the column of the referenced cell where "referenced cell" is the cell address within the () of those functions. "KW_Counter" wrote: I used to use a function where a formula would look in a cell to find what column or row it should use in the formula. Anyone know what this is callled? Thanks, KW_Counter |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Obscure Function | Excel Worksheet Functions | |||
| Combination chart: primary data labels obscure line series on secondary axis | Charts and Charting in Excel | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Obscure Question | Excel Discussion (Misc queries) | |||
Linear Mode
