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
---
"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