Dear All,
I'm trying to construct formulas in Col G which matches Col H.
My criteria to add matches in a string is located in cell M2.
Your help would be greatly appreciated.
Kind Regards
Biz
Excel 2013 32 bit
<tbody>
</tbody>
<tbody>
</tbody>
Excel 2013 32 bit
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
I'm trying to construct formulas in Col G which matches Col H.
My criteria to add matches in a string is located in cell M2.
Your help would be greatly appreciated.
Kind Regards
Biz
Excel 2013 32 bit
B | C | D | E | F | G | H | I | J | K | L | M | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Name | Category | Month | String | Cal | Should Be | Criteria | |||||
2 | Tom | Respite | 1/11/2016 | Respond,Other,Reassessed | 0 | 3 | Respond,Other,Reassessed | |||||
3 | Tom | Other | 1/11/2016 | Respond,Other,Reassessed | 0 | 3 | ||||||
4 | Tom | Reassessed | 1/11/2016 | Respond,Other,Reassessed | 0 | 3 | ||||||
5 | BK | Respite | 1/12/2016 | Respond | 1 | 1 | ||||||
6 | Tom | Other | 1/12/2016 | Other,Other | 0 | 2 | ||||||
7 | Tom | Other | 1/12/2016 | Other,Other | 0 | 2 | ||||||
8 | Spider | A | 1/12/2016 | A | 0 | 0 |
<tbody>
</tbody>
Sheet: Sheet2 |
<tbody>
</tbody>
Excel 2013 32 bit
B | C | D | E | F | G | H | I | J | K | L | M | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Name | Category | Month | String | Cal | Should Be | Criteria | |||||
2 | Tom | Respite | 1/11/2016 | Respond,Other,Reassessed | 0 | 3 | Respond,Other,Reassessed | |||||
3 | Tom | Other | 1/11/2016 | Respond,Other,Reassessed | 0 | 3 | ||||||
4 | Tom | Reassessed | 1/11/2016 | Respond,Other,Reassessed | 0 | 3 | ||||||
5 | BK | Respite | 1/12/2016 | Respond | 1 | 1 | ||||||
6 | Tom | Other | 1/12/2016 | Other,Other | 0 | 2 | ||||||
7 | Tom | Other | 1/12/2016 | Other,Other | 0 | 2 | ||||||
8 | Spider | A | 1/12/2016 | A | 0 | 0 |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet2
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>