How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1920
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

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 3 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 LaughingHAPPY FACELaughing


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



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