Hi,
Is there a way to put 2 lists of reference numbers (8 digit alphanumeric codes) in a spreadsheet so that it will distinguish between the codes that appear in both lists and those that only appear in one of the lists.
Thanks
Hi,
Is there a way to put 2 lists of reference numbers (8 digit alphanumeric codes) in a spreadsheet so that it will distinguish between the codes that appear in both lists and those that only appear in one of the lists.
Thanks
hi,
not sure what you want but this will show up the dupicates in both lists
assuming the lists are in column a and b
use this is in conditional formating
steve=COUNTIF($A$1:$b$100,A1)>1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks