richard1234567891011
Board Regular
- Joined
- Feb 21, 2018
- Messages
- 91
Hi Guys,
I Need help for a formula,
I need an indirect formula, (because the data are stored on another excel worksheet) in order to take it, without blank cells data.
Example:
the data are something like this:
<colgroup><col style="mso-width-source:userset;mso-width-alt:4790;width:98pt" width="131"> <col style="mso-width-source:userset;mso-width-alt:8265;width:170pt" width="226"> </colgroup><tbody>
</tbody>
Expected result inside the other worksheet with the originator file opened should be:
<colgroup><col><col></colgroup><tbody>
</tbody>
<tbody>
</tbody>
I hope it is clear,
Thank you guys,
I Need help for a formula,
I need an indirect formula, (because the data are stored on another excel worksheet) in order to take it, without blank cells data.
Example:
the data are something like this:
Stato | Luogo |
Reposses | Indefinito |
Terzi | Da definite |
Terzi | Da definite |
Terzi | Da definite |
Terzi | Da definite |
Terzi | Da definite |
Terzi | Da definite |
Terzi | Da definite |
Terzi | Da definite |
Reposses | Indefinito |
Terzi | Da definite |
Quarti | Da definite |
Reposses | Indefinito |
Reposses | Indefinito |
Terzi | Da definite |
Reposses | Indefinito |
Terzi | Da definite |
Quarti | Da definite |
Terzi | Da definite |
Quarti | Da definite |
Terzi | Da definite |
Quarti | Da definite |
Terzi | Da definite |
Quarti | Da definite |
Terzi | Da definite |
Quarti | Da definite |
Terzi | Da definite |
Quarti | Da definite |
Terzi | Da definite |
Quarti | Da definite |
Terzi | Da definite |
Quarti | Da definite |
Terzi | Da definite |
Quarti | Da definite |
Terzi | Da definite |
Quarti | Da definite |
Reposses | Indefinito |
<colgroup><col style="mso-width-source:userset;mso-width-alt:4790;width:98pt" width="131"> <col style="mso-width-source:userset;mso-width-alt:8265;width:170pt" width="226"> </colgroup><tbody>
</tbody>
Expected result inside the other worksheet with the originator file opened should be:
<colgroup><col><col></colgroup><tbody>
</tbody>
Stato | Luogo |
Reposses | Indefinito |
Reposses | Indefinito |
Reposses | Indefinito |
Reposses | Indefinito |
Reposses | Indefinito |
Reposses | Indefinito |
<tbody>
</tbody>
I hope it is clear,
Thank you guys,