I read your instructions on checking for duplicates but what if the rows are not aligned and the duplicate name is on the 4th row in 1 list and the 5th row in the other list. Because they are not aligned they appear as not a match. Is there just a way to see the names (or another data element ie. emails) that are not the same in both list?
MacBook Air 13″, macOS 11.7
I don't know what instruction you are referencing and how your "data bases" look like.
But here a simple solution.
B2=XLOOKUP(A2,Table 2::A,Table 2::A,"Not in list",0,1)
XLOOKUP will search for a name and if it will not find the name it will return "Not in list"
Now you know what name from table 1 is not included in table 2
For table 2 you would have to do the same thing.
Based on your region the , or the ; will be used to separate the different sections of a formula. If you write one thousand as 1,000.00 then the , is used as your formula separator. If you write one thousand as 1.000,00 then the ; is used as your formula separator.
Hope this will solve your question, please let me know if this worked for you or if something in unclear.
Regards Ralf
I don't know what instruction you are referencing and how your "data bases" look like.
But here a simple solution.
B2=XLOOKUP(A2,Table 2::A,Table 2::A,"Not in list",0,1)
XLOOKUP will search for a name and if it will not find the name it will return "Not in list"
Now you know what name from table 1 is not included in table 2
For table 2 you would have to do the same thing.
Based on your region the , or the ; will be used to separate the different sections of a formula. If you write one thousand as 1,000.00 then the , is used as your formula separator. If you write one thousand as 1.000,00 then the ; is used as your formula separator.
Hope this will solve your question, please let me know if this worked for you or if something in unclear.
Regards Ralf
checking for duplicates in two data bases
