Comparing and contrasting columns

M

mightymouse68

I really know very little about Excel and I need this answered for my
job. Any help would be greatly appreciated. In my job I'm often given
two spreadsheets with account numbers and first and last name. One
sheet has all of the accounts that we are given to bid on (with the
seller's account number) and one sheet has the accounts that we
actually bought (with seller's account number and our new account
number). I need to know if there is a way to compare the two and
extract only the accounts that are alike and our new account numbers
and put them in a new column. I hope someone follows this. It's
probably less complicated than I'm making it sound.
 
M

mightymouse68

Actually, I just read the "Compare two columns and find Diff." post and
your response. I can't seem to get it to work though. I can line up the
account numbers next to each other in columns and just sort by
ascending order and delete the ones that don't line up, but when you
are working with over 10,000 accounts it get to be very time consuming
to do that manually. Basically, I just need something that says "Hey
Excel, tell me what is in Column A that isn't in Column B."
 
P

pikapika13

in column C:

=IF(countif($A$1:$A$3000,$B1)=0,$B1,"")

then auto copy down...

This formula says: "Excel, look at Cell B1 and compare it to Column A.
If it is not found in A, then show me value of B1"


I'm in a rush...so I hope this works...if not..I'll be back tomorrow.


Regards, Pik
 
Top