Problem with highlighting date duplication

Hello, Gents!

I really need help on something here! I have a Workbook with two worksheets in it. In both sheets there are many numbers and letters per row, and I do have to compare them so as to find duplicates (crosschecking the values - 24k in one sheet and 1,2k in another).

But there is one little problem, sometimes they are not exact values, for example, sometimes the sequence is different, like "183003 / PAAE23" in one sheet and "PAAE23-183 003" in other, but still the same file. Is this case, how would I be able to find the duplicates? attached you can find the sheet Book1.xlsx.

E (column) sheet1 P (column) sheet 2
167046/ PAAE233013 PAAE23 3013 / 1670 46
167047/ PAAE233013 PAAE23 3013 / 1670 47
167048/ PAAE233013 PAAE23 3013 / 16704 8



Thanks in advance for your help !

Hi, FDibbins. Thanks for your answer!!

I think that most of the items are equal, sorry. But could you help me with crosschecking the sheets? For example, I'd like to highlight all the items that appear in the sheet 2 and are also in the sheet 1 and vice versa. Is that possible?

Thanks!

Simple vlookup could help.
The steps:
1. In sheet1 cell B1 copy paste this: =VLOOKUP(A1,Sheet2!A$1:A$284,1,FALSE)
The part “$284’ is the last row with data in sheet2, you may change it if the data changes.
Copy cell B1 > select B1 until the last row>paste
2. In sheet2 column B copy paste this: =VLOOKUP(A1,Sheet1!A$1:A$2250,1,FALSE)
The part “$2250’ is the last row with data in sheet1, you may change it if the data changes.
Copy cell B1 > select B1 until the last row>paste.

In column B, the ones with #N/A means there is no duplicates in the other sheet.
But this method doesn’t solve the ‘different sequence’ problem.

Note:
If you run into error, in the formula above, try to change character , to ; so it becomes:
=VLOOKUP(A1;Sheet2!A$1:A$284;1;FALSE)
=VLOOKUP(A1;Sheet1!A$1:A$2250;1;FALSE)
It’s a languange setting issue.

Woww!! Thanks a lot man! worked like a arrow and bow!!

Thanks to everyone!