Compare and copy in column
Closed
sigmasolve
Posts
1
Registration date
Friday January 16, 2015
Status
Member
Last seen
January 16, 2015
-
Jan 16, 2015 at 04:28 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Jan 20, 2015 at 02:46 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Jan 20, 2015 at 02:46 AM
I want to copy data in column 'B' when column 'A' is not blank.
'A' column has some blank rows. please
'A' column has some blank rows. please
Related:
- Compare and copy in column
- Beyond compare - Download - File management
- How to delete column in word - Guide
- Display two columns in data validation list but return only one - Guide
- Excel count occurrences of string in column - Guide
- Tweetdeck expand column - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Jan 19, 2015 at 07:29 AM
Jan 19, 2015 at 07:29 AM
Hello Sigmasolve,
If the blanks in Column A are not a problem for you, then enter the following formula in B2 (I am assuming that you have headings in A1 and B1):-
=IF(A2<>"",A2,"")
and then drag it down as far as you need.
Regards,
vcoolio.
If the blanks in Column A are not a problem for you, then enter the following formula in B2 (I am assuming that you have headings in A1 and B1):-
=IF(A2<>"",A2,"")
and then drag it down as far as you need.
Regards,
vcoolio.
Jan 19, 2015 at 07:10 PM
However, if this is not the case, then I feel the question needs to be clarified.
"copy data in column 'B' when column 'A' is not blank"
implies that the data in column B needs to be copied to somewhere else when A is blank.
Could be wrong though, who knows.
Jan 20, 2015 at 02:46 AM
At least the OP has a starting point to give us feed-back on.
A simple =A2 would probably suffice also.
Let's wait and see.
Cheers,
vcoolio.