C che Apr 12, 2005 #1 Please give me website about MAtch data. How can I match column a and b and the result will be on column c? Thanks
Please give me website about MAtch data. How can I match column a and b and the result will be on column c? Thanks
D Dave Peterson Apr 12, 2005 #2 Two for the price of one! Chip Pearson has tons of ways of working with duplicates at: http://www.cpearson.com/excel/duplicat.htm And Debra Dalgleish's instructions on =match() http://www.contextures.com/xlFunctions03.html
Two for the price of one! Chip Pearson has tons of ways of working with duplicates at: http://www.cpearson.com/excel/duplicat.htm And Debra Dalgleish's instructions on =match() http://www.contextures.com/xlFunctions03.html
A Arvi Laanemets Apr 12, 2005 #3 Hi When your data start from row 2 (row 1 is header): Into C2 enter the formula =IF(COUNTIF(B$2:B2,B2)>1,"Duplicate","") and copy down Arvi Laanemets
Hi When your data start from row 2 (row 1 is header): Into C2 enter the formula =IF(COUNTIF(B$2:B2,B2)>1,"Duplicate","") and copy down Arvi Laanemets
