MATCH
 

Please give me website about MAtch data.

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

Thanks

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


che wrote:

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

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


"che" wrote in message
...
Please give me website about MAtch data.

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

Thanks