#68 Full Compare not finding known difference

[Dan Moran]

I am comparing two database-style spreadsheets, the latter one containing an additional row (row # 2410) within the spreadsheet. The full compare is not detecting any differences between the two even though the first spreadsheet contains 2491 rows and the second one contains 2492 rows.

[SteveT]

If you are using the Database Compare, then that is the issue. Your Item Number field does not have unique keys. #2410 and #2409 have the same value which will cause the DB Compare to fail.

You can either:
1) Use the Quick Compare instead to identify any new rows:

and then align the rows manually and continue to the end:

2) It appears that column A through D together define the database key. If so, you could insert a column before your data and then create the key using =CONCATENATE(B2,C2,D2,E2). Then perform a DB Compare on that new column.

Steve

[Dan Moran]

Steve,
Thank you for looking at my problem. Sorry you had to spend time on my issue but I figured it was something simple I was missing. Actually columns A & D are the unique identifiers with column D having only four options so I have two options, the concatenated column as you suggested, or filter my data on column D and run multiple compares.
Thank you so much for your time and suggestions .
Best regards, Dan

[SteveT]

No problem!