Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert formula to text
I have a very long formula using
sumprodct(--isna(match(.....)),--match(....)). IN this formula, i'm comparing four columns and these columns are defined in four cells because they are not constant. The problem with this formula is that it is extremely slowing down the excel file. Any change made takes a long time to recalculate, but I can't turn calculation manual because I need other cells to change. Now that the formula is set in a cell, can I use a function/macro to convert the formula to text when this formula is not used and convert it back to formula when used? Thanks, Carmen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Text to a Formula | Excel Discussion (Misc queries) | |||
Convert Text to Formula | Excel Worksheet Functions | |||
How to convert formula to text | Excel Worksheet Functions | |||
convert text into Formula | Excel Discussion (Misc queries) | |||
how to convert a formula into text in order to display the formula | Excel Discussion (Misc queries) |