comparing data

  • Thread starter Thread starter singkit
  • Start date Start date
S

singkit

Hi,

I'd like to know if there is easier way to compare two
worksheet.
for example:
Sheet 1 contains 10000 records, it has

employee number 99456
employee name Jeanne Chua
TIN No 333 456 789

Sheet 2 contains 2000 records ,it also has the same field
but only thing is that there is some modification or
changes made

employee number 99456
employee name Jean Chua
TIN No 333 457 789

Note: if you look at the name and tin there is changes
how will I know those have changes in 2000 records

Thanks.
 
If the employee numbers are correct in both lists, then
this would be a relatively easy way to solve this:

- Make a list with all employee numbers
- Use the VLOOKUP formula to get the employee names and
TIN Nos belonging to the employee numbers in sheet 1 and
sheet 2
- compare the the results with the EXACT formula.

regards,
Hans
 
Suppose the 3 columns with data are A, B, and C in both
sheets. In D2 of Sheet2 (assuming headers in row 1), you
could use:

=IF(ISNA(MATCH(A2&B2&C2,Sheet1!A1:A10000&Sheet1!
B1:B10000&Sheet1!C1:C10000,0)),"Discrepancy","")

Array-entered (after inserting the formula, press
ctrl/shift/enter).

Then fill the formula down.

HTH
Jason
Atlanta, GA
 
Back
Top