Conditionally copy columns
Solved/Closed
GMHerbs
Posts
2
Registration date
Wednesday February 4, 2015
Status
Member
Last seen
February 4, 2015
-
Feb 4, 2015 at 10:26 PM
GMHerbs Posts 2 Registration date Wednesday February 4, 2015 Status Member Last seen February 4, 2015 - Feb 4, 2015 at 10:56 PM
GMHerbs Posts 2 Registration date Wednesday February 4, 2015 Status Member Last seen February 4, 2015 - Feb 4, 2015 at 10:56 PM
Related:
- Conditionally copy columns
- Display two columns in data validation list but return only one - Guide
- Excel copy column from one sheet to another automatically - Guide
- Excel change columns to numbers - Guide
- Google sheets right to left columns - Guide
- Excel partial text match between two columns - Guide
1 response
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
26
Feb 4, 2015 at 10:31 PM
Feb 4, 2015 at 10:31 PM
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.
=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.
Feb 4, 2015 at 10:56 PM