Conditionally copy columns [Solved/Closed]

GMHerbs 2 Posts Wednesday February 4, 2015Registration date February 4, 2015 Last seen - Feb 4, 2015 at 10:26 PM - Latest reply: GMHerbs 2 Posts Wednesday February 4, 2015Registration date February 4, 2015 Last seen
- Feb 4, 2015 at 10:56 PM
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
See more 

2 replies

Best answer
RayH 122 Posts Tuesday August 31, 2010Registration dateContributorStatus June 20, 2016 Last seen - Feb 4, 2015 at 10:31 PM
1
Thank you
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.

Thank you, RayH 1

Something to say? Add comment

CCM has helped 1699 users this month

GMHerbs 2 Posts Wednesday February 4, 2015Registration date February 4, 2015 Last seen - Feb 4, 2015 at 10:56 PM
Haha! Thank you that worked perfectly! Here I was trying much more difficult formulas. Thanks again!