|There are several ways to check for duplicates, here's two:|
In cell C1 enter the formula:
=IF(ISERROR(MATCH(A1,$B$1:$B$750,0)),"no match in Col B","")
Drag down 750 rows
This will tell you if a Number in Column A
does NOT have a matching number in Column B.
A second way is to use Conditional Formatting
Conditional Formatting 2007
1) Select your cell or range of cells: A1:B750
2) On the ribbon click Conditional Formatting
3) Click on Highlight Cell Rules,.
4) Click Duplicate Values.
5) In the input box, Select Unique Values
9) Click OK
Those values that are Unique, with no matches should be highlighted.
See how those work for you.