| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
| automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| formulas for changing formulas? | Excel Discussion (Misc queries) | |||
Linear Mode
