using IF function to copy, but leave populated cell alone
Not exactly (thanks for the try)... that puts a blank where some test
was that I want to keep.
It would be more like =IF(A1="yes","yes", DO NOTHING)
where do nothing means leave that cell alone!
Befo
A B
1 example text (blank)
2 BlahBla goodstuff
3 example text (blank)
After:
A B
1 example text example text
2 BlahBla goodstuff
3 example text example text
|