How to replace a function with its result or resulting reference in a formula?
I need to replace in 1000 cells automatically.
"Dmitry Kopnichev" сообщил/сообщила в новостях следующее:
...
Hello
How to replace a function with its result in a formula? For example,
=INDEX(...)+INDEX(...) with
=result_of_INDEX(a...)+result_of_INDEX(b...)=1025+ 1307.
How to replace a function with its resulting reference in a formula? For
example, =HLOOKUP(1...)+HLOOKUP(2...) with =b11+z11.
|