| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to determine the cell location?
Does anyone have any suggestions on how to determine the cell location within
table? The range of table is from C10 to AU54, there is a list of numbers within this table Starting from C10 is 1, D10 is 56, ... AU10 is 1981 C11 is 2, D11 is 57, ... AU11 is 1982 C12 is 3, D12 is 58, ... AU12 is 1983 .... C54 is 45, D54 is 90, ... AU54 is 2025 There is a given value in BB1, which is 197, it should return the cell location G26 in cell BB2. Does anyone have any suggesitons? Thanks in advance for any suggestions Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
| automatic offset cell location when there is a value in a selected cell. | Excel Worksheet Functions | |||
| in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell? | Excel Worksheet Functions | |||
| Determine the location of an external source of pivot table? | Excel Worksheet Functions | |||
| Function to determine if any cell in a range is contained in a given cell | Excel Worksheet Functions | |||
Threaded Mode
