G Guest Apr 23, 2004 #1 I have two columns of serial numbers, I need to identify any numbers common to both lists. Is there a function to do this?
I have two columns of serial numbers, I need to identify any numbers common to both lists. Is there a function to do this?
F Frank Kabel Apr 23, 2004 #2 Hi have a look at http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon -----Original Message----- I have two columns of serial numbers, I need to identify Click to expand... any numbers common to both lists. Is there a function to do this?
Hi have a look at http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon -----Original Message----- I have two columns of serial numbers, I need to identify Click to expand... any numbers common to both lists. Is there a function to do this?
G Guest Apr 23, 2004 #3 Assuming you have one set of serial numbers in column A and another set in column B (both starting in row 2 In C2, ente =if(not(isna(vlookup(A2,$B$2:$B$1000,1,false))),"IN BOTH LISTS","" and copy dow change 1000 to reflect the end row of the list in Col Hope this help Geoff
Assuming you have one set of serial numbers in column A and another set in column B (both starting in row 2 In C2, ente =if(not(isna(vlookup(A2,$B$2:$B$1000,1,false))),"IN BOTH LISTS","" and copy dow change 1000 to reflect the end row of the list in Col Hope this help Geoff
