Arjen Bakker
New Member
- Joined
- Sep 27, 2017
- Messages
- 19
[TABLE="width: 263"]
<colgroup><col width="31" style="width: 23pt; mso-width-source: userset; mso-width-alt: 1133;"> <col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1462;" span="8"> <tbody>[TR]
[TD="class: xl81, width: 71, bgcolor: transparent, colspan: 2"]Hello folks[/TD]
[TD="class: xl81, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl80, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl80, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl81, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl80, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl80, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl80, width: 40, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl81, bgcolor: transparent, colspan: 9"]unfortunately working with somehow strange set of data. See below.[/TD]
[/TR]
[TR]
[TD="class: xl81, bgcolor: transparent, colspan: 9"]Is it nevertheless possible to have a formula that shows people working[/TD]
[/TR]
[TR]
[TD="class: xl81, bgcolor: transparent, colspan: 4"]on day 3 with acivity "c" ? (Column I)[/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl81, bgcolor: transparent"][TABLE="width: 263"]
<tbody>[TR]
[TD="class: xl81, bgcolor: transparent, colspan: 5"]Thanks very much for your help
Arjen
[TABLE="width: 263"]
<colgroup><col width="31" style="width: 23pt; mso-width-source: userset; mso-width-alt: 1133;"> <col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1462;" span="8"> <tbody>[TR]
[TD="class: xl80, width: 31, bgcolor: transparent"][/TD]
[TD="class: xl82, width: 40, bgcolor: transparent"] A[/TD]
[TD="class: xl82, width: 40, bgcolor: transparent"] B[/TD]
[TD="class: xl82, width: 40, bgcolor: transparent"] C[/TD]
[TD="class: xl82, width: 40, bgcolor: transparent"] D[/TD]
[TD="class: xl82, width: 40, bgcolor: transparent"] E[/TD]
[TD="class: xl82, width: 40, bgcolor: transparent"] G [/TD]
[TD="class: xl82, width: 40, bgcolor: transparent"] H[/TD]
[TD="class: xl82, width: 40, bgcolor: transparent"] I[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"]1[/TD]
[TD="class: xl83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]Code1[/TD]
[TD="class: xl84, bgcolor: #FFF2CC"]Code2[/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"]2[/TD]
[TD="class: xl83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]3[/TD]
[TD="class: xl84, bgcolor: #FFF2CC"]c[/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"]3[/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl90, bgcolor: blue, colspan: 2"]Wished[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"]4[/TD]
[TD="class: xl85, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] , colspan: 5"]Code1 (work days)[/TD]
[TD="class: xl84, bgcolor: #FFF2CC"]Code2[/TD]
[TD="class: xl89, bgcolor: blue"]Name[/TD]
[TD="class: xl86, bgcolor: blue"]Result[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"]5[/TD]
[TD="class: xl87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]1[/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]2[/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]3[/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "] [/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]5[/TD]
[TD="class: xl84, bgcolor: #FFF2CC"]c[/TD]
[TD="class: xl89, bgcolor: blue"]A[/TD]
[TD="class: xl89, bgcolor: blue"]A[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"]6[/TD]
[TD="class: xl87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]1[/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]2[/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "] [/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]4[/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "] [/TD]
[TD="class: xl84, bgcolor: #FFF2CC"]a[/TD]
[TD="class: xl89, bgcolor: blue"]A[/TD]
[TD="class: xl89, bgcolor: blue"]NA[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"]7[/TD]
[TD="class: xl87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "] [/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]2[/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]3[/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]4[/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]5[/TD]
[TD="class: xl84, bgcolor: #FFF2CC"]c[/TD]
[TD="class: xl89, bgcolor: blue"]C[/TD]
[TD="class: xl89, bgcolor: blue"]C[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"]8[/TD]
[TD="class: xl87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]1[/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "] [/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "] [/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "] [/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]5[/TD]
[TD="class: xl84, bgcolor: #FFF2CC"]d[/TD]
[TD="class: xl89, bgcolor: blue"]C[/TD]
[TD="class: xl89, bgcolor: blue"]NA[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="class: xl81, bgcolor: transparent"]
[/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl81, bgcolor: transparent, colspan: 5"][/TD]
[TD="class: xl81, bgcolor: transparent"]
[/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
<colgroup><col width="31" style="width: 23pt; mso-width-source: userset; mso-width-alt: 1133;"> <col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1462;" span="8"> <tbody>[TR]
[TD="class: xl81, width: 71, bgcolor: transparent, colspan: 2"]Hello folks[/TD]
[TD="class: xl81, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl80, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl80, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl81, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl80, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl80, width: 40, bgcolor: transparent"][/TD]
[TD="class: xl80, width: 40, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl81, bgcolor: transparent, colspan: 9"]unfortunately working with somehow strange set of data. See below.[/TD]
[/TR]
[TR]
[TD="class: xl81, bgcolor: transparent, colspan: 9"]Is it nevertheless possible to have a formula that shows people working[/TD]
[/TR]
[TR]
[TD="class: xl81, bgcolor: transparent, colspan: 4"]on day 3 with acivity "c" ? (Column I)[/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl81, bgcolor: transparent"][TABLE="width: 263"]
<tbody>[TR]
[TD="class: xl81, bgcolor: transparent, colspan: 5"]Thanks very much for your help
Arjen
[TABLE="width: 263"]
<colgroup><col width="31" style="width: 23pt; mso-width-source: userset; mso-width-alt: 1133;"> <col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1462;" span="8"> <tbody>[TR]
[TD="class: xl80, width: 31, bgcolor: transparent"][/TD]
[TD="class: xl82, width: 40, bgcolor: transparent"] A[/TD]
[TD="class: xl82, width: 40, bgcolor: transparent"] B[/TD]
[TD="class: xl82, width: 40, bgcolor: transparent"] C[/TD]
[TD="class: xl82, width: 40, bgcolor: transparent"] D[/TD]
[TD="class: xl82, width: 40, bgcolor: transparent"] E[/TD]
[TD="class: xl82, width: 40, bgcolor: transparent"] G [/TD]
[TD="class: xl82, width: 40, bgcolor: transparent"] H[/TD]
[TD="class: xl82, width: 40, bgcolor: transparent"] I[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"]1[/TD]
[TD="class: xl83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]Code1[/TD]
[TD="class: xl84, bgcolor: #FFF2CC"]Code2[/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"]2[/TD]
[TD="class: xl83, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]3[/TD]
[TD="class: xl84, bgcolor: #FFF2CC"]c[/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"]3[/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl90, bgcolor: blue, colspan: 2"]Wished[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"]4[/TD]
[TD="class: xl85, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] , colspan: 5"]Code1 (work days)[/TD]
[TD="class: xl84, bgcolor: #FFF2CC"]Code2[/TD]
[TD="class: xl89, bgcolor: blue"]Name[/TD]
[TD="class: xl86, bgcolor: blue"]Result[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"]5[/TD]
[TD="class: xl87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]1[/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]2[/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]3[/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "] [/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]5[/TD]
[TD="class: xl84, bgcolor: #FFF2CC"]c[/TD]
[TD="class: xl89, bgcolor: blue"]A[/TD]
[TD="class: xl89, bgcolor: blue"]A[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"]6[/TD]
[TD="class: xl87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]1[/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]2[/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "] [/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]4[/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "] [/TD]
[TD="class: xl84, bgcolor: #FFF2CC"]a[/TD]
[TD="class: xl89, bgcolor: blue"]A[/TD]
[TD="class: xl89, bgcolor: blue"]NA[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"]7[/TD]
[TD="class: xl87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "] [/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]2[/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]3[/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]4[/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]5[/TD]
[TD="class: xl84, bgcolor: #FFF2CC"]c[/TD]
[TD="class: xl89, bgcolor: blue"]C[/TD]
[TD="class: xl89, bgcolor: blue"]C[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"]8[/TD]
[TD="class: xl87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]1[/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "] [/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "] [/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "] [/TD]
[TD="class: xl88, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DBDBDB]#DBDBDB[/URL] "]5[/TD]
[TD="class: xl84, bgcolor: #FFF2CC"]d[/TD]
[TD="class: xl89, bgcolor: blue"]C[/TD]
[TD="class: xl89, bgcolor: blue"]NA[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="class: xl81, bgcolor: transparent"]
[/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl81, bgcolor: transparent, colspan: 5"][/TD]
[TD="class: xl81, bgcolor: transparent"]
[/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]