Insert the results of a formula into a comment for the same cell

L

Logan Nalley

I have a cell that is using an index to pull the owners cost. I would like to add a comment or data validation to that same cell that runs a different formula to show the customers cost. This way I only see the owners cost and by selecting the cell I then see the customers cost

Thanks
 
D

Dave Peterson

I bet you could do this, but I'd try to make my life a little easier.

I'd use another column and just hide/unhide it when necessary.
 
J

Jack Sons

Logan,

What you want to do is possible.
David Hager might send you on your request his impressive
"FormulaComments.xls". Using this you can have in a comment a real formula
that wil be recalculated just as if it were a "normal" formula in a cell.
I do possess that xls but to my regret I don't know his email address, but
many of the gurus in this NG will know.
HTH.

Jack Sons
The Netherlands


Logan Nalley said:
I have a cell that is using an index to pull the owners cost. I would like
Click to expand...
to add a comment or data validation to that same cell that runs a different
formula to show the customers cost. This way I only see the owners cost and
by selecting the cell I then see the customers cost.
 
Top