Conditionally copy columns
Solved/Closed
GMHerbs
Posts
2
Registration date
Wednesday 4 February 2015
Status
Member
Last seen
4 February 2015
-
4 Feb 2015 à 22:26
GMHerbs Posts 2 Registration date Wednesday 4 February 2015 Status Member Last seen 4 February 2015 - 4 Feb 2015 à 22:56
GMHerbs Posts 2 Registration date Wednesday 4 February 2015 Status Member Last seen 4 February 2015 - 4 Feb 2015 à 22:56
Related:
- Conditionally copy columns
- Tweetdeck larger columns - Guide
- How to delete columns in word - Guide
- Excel drop down list multiple columns - Guide
- Excel change columns to numbers - Guide
- Excel partial text match between two columns - Guide
1 response
RayH
Posts
122
Registration date
Tuesday 31 August 2010
Status
Contributor
Last seen
20 June 2016
26
4 Feb 2015 à 22:31
4 Feb 2015 à 22:31
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.
4 Feb 2015 à 22:56