Associate
- Joined
- 26 Jun 2005
- Posts
- 1,487
Afternoon all,
I have two lists of data, one Master file with 23000 (in column A) entries and my list with about 400 entries (in column C and a different workbook). The data in each cell is a mixture of letters and numbers so sorting alphabetically doesn't work.
I need to check that all my 400 entries are on the Master file and highlight any duplicates and those that aren't listed.
Can anyone devise a formula that will do this?
Thanks
I have two lists of data, one Master file with 23000 (in column A) entries and my list with about 400 entries (in column C and a different workbook). The data in each cell is a mixture of letters and numbers so sorting alphabetically doesn't work.
I need to check that all my 400 entries are on the Master file and highlight any duplicates and those that aren't listed.
Can anyone devise a formula that will do this?
Thanks