Hello list,
How would I refer to the text of a formula in another formula? For ex:
If I have the following formula
=SUBTOTAL(3,D2:D10) which equals 9
I would like to extract the range D2:D10 out and use it in another formula. However all that I'm geting is the result of the formula (9) not the "text" of the formula.
How do you do this?
How would I refer to the text of a formula in another formula? For ex:
If I have the following formula
=SUBTOTAL(3,D2:D10) which equals 9
I would like to extract the range D2:D10 out and use it in another formula. However all that I'm geting is the result of the formula (9) not the "text" of the formula.
How do you do this?