| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate cell reference
I need to calculate a cell reference with a formula.
For instance: Instead of using =D6 I need to have excel calculate the '6' portion -- like this =D&(COUNTIF(D6:D32,"<50")) so it will use the result of the function to determine the cell number. I have not been able to successfully reference a cell using a formula. Is this even possible? Thanks, Jesse |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Reference: won't auto-calculate, among other things | Excel Worksheet Functions | |||
| How to calculate (generate) a cell reference | New Users to Excel | |||
| Auto calculate absolute cell reference | Excel Discussion (Misc queries) | |||
| Formula 'mis' calculate when reference cell contains a "0" | Excel Discussion (Misc queries) | |||
| How to 'Calculate' an Excel Reference | Excel Discussion (Misc queries) | |||
Threaded Mode
