wow...great...

many many thanks....

reza

"Jacob Skaria" wrote:

In cell F1 try the below formula and copy down as required

=A1 & ", " & IF(COUNTIF(B1:E1,B1)=4,B1+0&" respondent closed, already
completed and pass QC",C1+0&" from "&B1+0&" respondent, "&D1+0&" complete &
"& IF(E1<=0,"not yet pass QC",E1&" pass QC"))

If this post helps click Yes
---------------
Jacob Skaria


"reza" wrote:

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