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
give me solution!
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.