I have 2 columns filled with Numbers.
0000004655215 0068958355023 Duplicate
0000007745443 0000004655215 Unique
I'm currently using this formula in column 3:
=IF(ISERROR(MATCH(A1,$B$1:$B$10000,0)),"Unique","Duplicate")
I need to edit this formula to ignore leading zeros when the formula makes the decision. So the formula would yield for example:
0000004655215 0068958355023 Duplicate
0000007745443 0000004655215 Duplicate
0000888848943 7745443 Unique
How do I edit the formula to yield this result?![]()
![]()
All help is greatly appreciated.![]()
Bookmarks