I have a workbook with monthly account lisitngs. Each month is on a seperate worksheet and the customer lists are simelar. I need to compare the two lists - match up the numbers for each identical customer name and identify any rows that are on one month's report but not on another. Any suggestions?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel question - comparing two lists 1
- Thread starter skygirl65
- Start date
-
1
- #2
You could a column a formulae next to each list, and use a formula like:
changing the references to suit your needs. This will return a list of TRUE and FALSE depending on whether the values are in the other list or not.
Cheers, Glenn.
Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
Code:
=NOT(ISNA(MATCH(A4,Sheet2!$A$4:$A$99,0)))Cheers, Glenn.
Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
- Status