How JustAnswer Works:
• Ask an Expert
• Get a Professional Answer
• 100% Satisfaction Guarantee
Ask The-PC-Guy Your Own Question
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 2011
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now

# Comparing Two Columns in Excel 2007

This answer was rated:
I'm using Excel 2007. I have two columns(A & B) of ticket numbers. I would like to compare the two columns against each other. If column B has any of the same ticket numbers that A has, I would like those removed from column B and place into column C.Can ya help me out?
Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question

What row does your data start on?
Customer: replied 4 years ago.
Hi Andrew,
The data begins in Row 1 for both columns. However, Column A has 2572 rows, and Column B has 2926 rows.
ok it doesn't matter how many rows. Just needed to know the start row to give proper formula.

Just so you know this formula doesn't remove numbers from Column B, what it will do is compare the numbers in B and A, and put any numbers that match in Column C, and a blank wherever they don't match.

Enter the following into cell C1, then copy down the C collumn, for as many rows as you have numbers in collumn B

=IFERROR(VLOOKUP(B1,A:A,1,FALSE),"")

Let me know if you get stuck with this formula.

PLEASE DON'T FORGET TO RATE SO I AM PAID FOR MY TIME

IT WILL NOT COST ANYTHING ADDITIONAL BEYOND THE VALUE OF YOUR QUESTION

TO RATE, CLICK THE HAPPY FACE

BONUS IS APPRECIATED IF YOU FEEL I DID AN ESPECIALLY GOOD JOB

The-PC-Guy and 5 other Microsoft Office Specialists are ready to help you