Try this

Paste this formula in C2 cell and drag it to the remaining cell

=IF(B2="","",IF(COUNTIF(B:B,B2)1,"X","0"))

If this post helps, Click Yes!

--------------------
(MS-Exl-Learner)
--------------------



"linh lass" wrote:

i have data:
stage name result
1 ab
1 aa
1 abc
1 cd
1 ca
2 ds
2 ad
2 ab
2 ac
2 cc

if "name" in stage 1 = "name" in stage 2, then result "x"
example:
stage name result
1 ab x
1 aa 0
1 abc 0
1 cd 0
1 ca 0
2 ds 0
2 ad 0
2 ab x
2 ac 0
2 cc 0
Please, help me!
Thanks a lot

--
thanks alot
xxxxxxxxxx