CsJHUN
Active Member
- Joined
- Jan 13, 2015
- Messages
- 360
- Office Version
- 365
- 2021
- 2019
- Platform
- Windows
- Mobile
Hello guys,
I need your help again,i have this as an input
<colgroup><col style="mso-width-source:userset;mso-width-alt:3808;width:89pt" width="119"> <col style="mso-width-source:userset;mso-width-alt:3744; width:88pt" width="117" span="2"> <col style="mso-width-source:userset;mso-width-alt:3776;width:89pt" width="118"> </colgroup><tbody>
</tbody>I would like to get a result like this
<colgroup><col style="mso-width-source:userset;mso-width-alt:3808;width:89pt" width="119"> <col style="mso-width-source:userset;mso-width-alt:3744; width:88pt" width="117" span="2"> <col style="mso-width-source:userset;mso-width-alt:3776;width:89pt" width="118"> </colgroup><tbody>
</tbody>
Basicly every text value separated with "/" for each cell in range("A2:B2") resulted as a 2D matrix. I need this for advanced filter a table.
Please see it as like this: (ValA or ValB orValE) and (ValT or ValG) and (ValA/ValC) and (ValF).
Cannot be sure it will be always 3-2-2-1 filter value in the cells, it could be i-j-k-l (this could be 1-1-1-2, or 2-1-2-2, or 18-2-21-53, or ... i guess u get it, BTW the max numbers could be 62-28-6-5)
Any advice, code, code snippets are welcome.
Thanks!
I need your help again,i have this as an input
Colum A Headline | Colum B Headline | Colum C Headline | Colum D Headline |
ValA/ValB/ValE | ValT/ValG | ValA/ValC | ValF |
<colgroup><col style="mso-width-source:userset;mso-width-alt:3808;width:89pt" width="119"> <col style="mso-width-source:userset;mso-width-alt:3744; width:88pt" width="117" span="2"> <col style="mso-width-source:userset;mso-width-alt:3776;width:89pt" width="118"> </colgroup><tbody>
</tbody>
Colum A Headline | Colum B Headline | Colum C Headline | Colum D Headline |
ValA | ValT | ValA | ValF |
ValA | ValT | ValC | ValF |
ValA | ValG | ValA | ValF |
ValA | ValG | ValC | ValF |
ValB | ValT | ValA | ValF |
ValB | ValT | ValC | ValF |
ValB | ValG | ValA | ValF |
ValB | ValG | ValC | ValF |
ValE | ValT | ValA | ValF |
ValE | ValT | ValC | ValF |
ValE | ValG | ValA | ValF |
ValE | ValG | ValC | ValF |
<colgroup><col style="mso-width-source:userset;mso-width-alt:3808;width:89pt" width="119"> <col style="mso-width-source:userset;mso-width-alt:3744; width:88pt" width="117" span="2"> <col style="mso-width-source:userset;mso-width-alt:3776;width:89pt" width="118"> </colgroup><tbody>
</tbody>
Basicly every text value separated with "/" for each cell in range("A2:B2") resulted as a 2D matrix. I need this for advanced filter a table.
Please see it as like this: (ValA or ValB orValE) and (ValT or ValG) and (ValA/ValC) and (ValF).
Cannot be sure it will be always 3-2-2-1 filter value in the cells, it could be i-j-k-l (this could be 1-1-1-2, or 2-1-2-2, or 18-2-21-53, or ... i guess u get it, BTW the max numbers could be 62-28-6-5)
Any advice, code, code snippets are welcome.
Thanks!