Previous Topic Next Topic

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!

Compare and copy in column
Excel - Compare data from two columns - How-To - Excel
Compare values in two columns and return the value from third ✓ - Forum - Excel
Compare cells of two columns excel 2007 ✓ - Forum - Excel
Need formula for comparing differences of two columns. ✓ - Forum - Excel
Comparing data in 3 columns on a Microsoft Excel spreadsheet ✓ - Forum - Excel

1 reply

Answer 1 / 1

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.

RayH
Jan 19, 2015 at 07:10 PM

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.

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.

Subscribe To Our Newsletter!