how to check data to find the same

[linh lass]

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

 

[Max]

One way/logic you could use here ..
Assuming data shown in A1:B1 down
In C1: =IF(SUMIF(B:B,B1,A:A)=3,"x","")
Copy down
Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[MS-Exl-Learner]

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!