Copying concatenate not returning correct cell information
Yes, thank you. There are no absolute references in the formula.
"leerem" wrote:
When copying ensure you delete any absolute references eg. the $ (dollar
sign) before your reference eg $B$1 should be altered to B1
"Aneka" wrote:
A1 B1-B200
concat unique
formula numbers
I am using a concatenate formula in column A that uses column B as a
variable. When I copy the formula down the spreadsheet, the formula reflects
the cell change (from B1 to B2, for example). However, when I copy/paste the
results of the formula from A2 into a text doc (which should contain the
number in B2) it is retaining the number from B1.
How do I rectify this?
|