Matching column information

  • Thread starter Thread starter mePenny
  • Start date Start date
M

mePenny

I am in charge of a list containing license plates and fuel card numbers.
Once a month i'm sent an updated list. It takes me forever to compair all
this information. Is there a formula where I can compair the rows and it will
show me what is the same and what is changed?

Example of info

CB-045FR 03221
first group is the license plate, second is the fuel card number.
 
If you had the old info in A1:A100 and the new info in D1:D100, in say E1,

=A1=D1 and drag down to E100

This will return TRUE or FALSE so you would just look for the FALSE's

You can do the same if the two lists were in different sheets or different
workbooks,

Regards,
Alan.
 
Actually, the lists are on two different work sheets. The info i need to
compare is two columns from each sheet. what formula would I use and where
would you place it?
 
Say you are comparing columns A and B in Sheet1 to the same columns in
Sheet2, try

=Sheet!A1&B1=Sheet2!A1&B1

Gives TRUE for an exact match, FALSE if anythings diferent.
 
I've noticed that the information is not exactly the same on both sheets.
they both have card numbers and license plate numbers but they are scattered.
can I compare in another way?

Penny
 
mePenny said:
I've noticed that the information is not exactly the same on both sheets.
they both have card numbers and license plate numbers but they are scattered.
can I compare in another way?
Click to expand...
What do you mean by scattered? I don't see how you can possibly compare
them.

Bill
 
Try sorting both lists by the license numbers and use the formula I
suggested, then sort them by the fuel card numbers and do the same.
I'm not that sure how these lists are constructed obviously. Are there
numbers in one list that don't exist in the other?
Something has to be constant, one number or the other to do a direct
comparison between say Sheet1!A1 and Sheet2!A1 and they have to be in the
same cell, or at least the same order.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Swapping Columns 3
Still in need of help 3
Referencing the same cells 6
Excel Counting unique values in Excel, based on criteria. 5
Macro or formula to compare columns and give a result of the odd o 2
Form displaying multiple records in subtable, when only one exists 1
excluding records based on a table 3
Formulae attaching external workbook with named reference 2

Back
Top