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


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

[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


"che" <[email protected]> wrote in message
news:[email protected]...
> Please give me website about MAtch data.
>
> How can I match column a and b and the result will be on
> column c?
>
> Thanks