K kpk May 1, 2008 #1 I have two columns, 1 with 3800 entries and 2 with 1500 entries. I want to find the entries which are in column 1 but not in column 2.
I have two columns, 1 with 3800 entries and 2 with 1500 entries. I want to find the entries which are in column 1 but not in column 2.
D Dave Peterson May 2, 2008 #2 I'd use a formula like this in a helper column: =isnumber(match(a1,sheet2!a:a,0)) and drag down. True means that a1 appears in sheet2, column A. If that's not enough... Chip Pearson has lots of techniques to work with duplicates: http://www.cpearson.com/excel/Duplicates.aspx
I'd use a formula like this in a helper column: =isnumber(match(a1,sheet2!a:a,0)) and drag down. True means that a1 appears in sheet2, column A. If that's not enough... Chip Pearson has lots of techniques to work with duplicates: http://www.cpearson.com/excel/Duplicates.aspx
