contrain
asked on
excel 2016 compare two worksheets in different workbooks for differences
excel 2016 compare two worksheets in different workbooks for differences. I have similar data on spreadsheets in 2 different workbooks and would like to compare them for differences.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you comparing for existence of one record in one and not in the other?
Does each record have a unique ID that can be used?
Is each record a single row?