|
IF formulas
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 |
IF formulas
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 |
IF formulas
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 |
IF formulas
Jacob...
can you add more result... Line Col A Col B Col C Col D Col E 4 DD 5 3 0 0 with result DD, 3 from 5 respondent, not complete & not yet pas QC thanks again "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 |
IF formulas
Try modifying the previous one before trying the below....It is easy..
=A4 & ", " & IF(COUNTIF(B4:E4,B4)=4,B4+0&" respondent closed, already completed and pass QC",C4+0&" from "&B4+0&" respondent, "& IF(D4<=0,"not complete & ",D4&" complete & ") & IF(E4<=0,"not yet pass QC",E4&" pass QC")) If this post helps click Yes --------------- Jacob Skaria "reza" wrote: Jacob... can you add more result... Line Col A Col B Col C Col D Col E 4 DD 5 3 0 0 with result DD, 3 from 5 respondent, not complete & not yet pas QC thanks again "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 |
IF formulas
wow...great again...
you really - really save my time for doing a work... many thanks jacob "Jacob Skaria" wrote: Try modifying the previous one before trying the below....It is easy.. =A4 & ", " & IF(COUNTIF(B4:E4,B4)=4,B4+0&" respondent closed, already completed and pass QC",C4+0&" from "&B4+0&" respondent, "& IF(D4<=0,"not complete & ",D4&" complete & ") & IF(E4<=0,"not yet pass QC",E4&" pass QC")) If this post helps click Yes --------------- Jacob Skaria "reza" wrote: Jacob... can you add more result... Line Col A Col B Col C Col D Col E 4 DD 5 3 0 0 with result DD, 3 from 5 respondent, not complete & not yet pas QC thanks again "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 |
| All times are GMT +1. The time now is 12:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com