Hi Expert....

guys...hope you can help me with formulas...(ms Excel 2007)
Line Col A Col B Col C Col D
Col E
1 AA 10 5 4
2
2 BB 6 2 2
-
3 CC 8 8 8
8

Col A : name
Col B ; Baseline

from above i want to have result like:
AA, 5 from 10 respondent, 4 complete & 2 pass QC
BB, 2 from 6 respondent, 2 complete & not yet pass QC
CC, 8 respondent closed, already completed & pass QC (since all values
already same with col B)

hope you can helps me

thanks in advance

reza