Compare and copy in column
Closed
sigmasolve
vcoolio
- Posts
- 1
- Registration date
- Friday January 16, 2015
- Status
- Member
- Last seen
- January 16, 2015
vcoolio
- Posts
- 1345
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- May 20, 2022
Related:
- 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
vcoolio
Jan 19, 2015 at 07:29 AM
- Posts
- 1345
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- May 20, 2022
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.