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
1345
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 20, 2022
- 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
give me solution!            
                

1 reply

vcoolio
Posts
1345
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 20, 2022
249
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.
0
If this is truly what is required then simply copying A and pasting into B would work too without the hassle of using formulas.

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.
0
vcoolio
Posts
1345
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 20, 2022
249 > RayH
Jan 20, 2015 at 02:46 AM
That's right ,Ray. Who knows?

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.
0