A formula to copy the values from a formula to another column
I have a column of values created from a formula, I know I can copy the
values over to another column by using the clipboard. BUT...I want my
spreadsheet to be automatic whilst avoiding the use of VBA coding, so it
would be ideal if I could create a formula for the next column which
copies the VALUES over to the next column. Maybe an INDEX/MATCH kind of
method but one that copies ONLY the values rather than the formulas.
So in essence I want a formula to copy the values from a formula....
No comments:
Post a Comment