MATCH

[che]

Please give me website about MAtch data.

How can I match column a and b and the result will be on
column c?

Thanks

 

[Dave Peterson]

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

 

[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