| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to replace a function with its resulting reference in a formula?
Hello
How to replace a function with its resulting reference in a formula? For example, How to replace =HLOOKUP(1...)+HLOOKUP(2...) with =b11+z11. I need to replace in 1000 formulas/cells automatically. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA function for "Mean" using Array as argument | Excel Worksheet Functions | |||
| Replace "insert function" with "edit formula" button in fourmula b | Excel Discussion (Misc queries) | |||
| REPLACE outside of highlighted column | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Threaded Mode
