Conditionally copy columns [Solved/Closed]

Report
Posts
2
Registration date
Wednesday February 4, 2015
Status
Member
Last seen
February 4, 2015
-
GMHerbs
Posts
2
Registration date
Wednesday February 4, 2015
Status
Member
Last seen
February 4, 2015
-
Hello, I have a table with thousands of rows of text. Column B has errors in the data which I have fixed in column C (has many blank cells). I would like to copy the data from column B into column D unless there is a value in column C, in which case I would like to copy the data in column C. I've tried several formulas to no avail. Any help would be greatly appreciated.
Thanks

1 reply

Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
Could it be a simple as this?

=IF(C2<>"",C2,B2)

Put this is D2 and drag it down.

Bear in mind that the column will still contain a formula, so to make sure you have the actual values copy the cells from D and then in another column PasteSpecial values.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3984 users have said thank you to us this month

GMHerbs
Posts
2
Registration date
Wednesday February 4, 2015
Status
Member
Last seen
February 4, 2015

Haha! Thank you that worked perfectly! Here I was trying much more difficult formulas. Thanks again!