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>
[TD="class: xl63, width: 131"]Stato[/TD]
[TD="class: xl63, width: 226"]Luogo[/TD]
[TD="class: xl64"]Reposses[/TD]
[TD="class: xl65"]Indefinito[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Reposses[/TD]
[TD="class: xl65"]Indefinito[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Reposses[/TD]
[TD="class: xl65"]Indefinito[/TD]
[TD="class: xl64"]Reposses[/TD]
[TD="class: xl65"]Indefinito[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Reposses[/TD]
[TD="class: xl65"]Indefinito[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Reposses[/TD]
[TD="class: xl65"]Indefinito
[/TD]
</tbody>
Expected result inside the other worksheet with the originator file opened should be:
[TABLE="width: 357"]
<colgroup><col><col></colgroup><tbody>[TR]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
<tbody>
[TD="class: xl65, width: 131"]Stato
[/TD]
[TD="class: xl65, width: 226"]Luogo[/TD]
[TD="class: xl66"]Reposses[/TD]
[TD="class: xl67"]Indefinito[/TD]
[TD="class: xl66"]Reposses[/TD]
[TD="class: xl67"]Indefinito[/TD]
[TD="class: xl66"]Reposses[/TD]
[TD="class: xl67"]Indefinito[/TD]
[TD="class: xl66"]Reposses[/TD]
[TD="class: xl67"]Indefinito[/TD]
[TD="class: xl66"]Reposses[/TD]
[TD="class: xl67"]Indefinito[/TD]
[TD="class: xl66"]Reposses[/TD]
[TD="class: xl67"]Indefinito[/TD]
</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:
<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>
[TD="class: xl63, width: 131"]Stato[/TD]
[TD="class: xl63, width: 226"]Luogo[/TD]
[TD="class: xl64"]Reposses[/TD]
[TD="class: xl65"]Indefinito[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Reposses[/TD]
[TD="class: xl65"]Indefinito[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Reposses[/TD]
[TD="class: xl65"]Indefinito[/TD]
[TD="class: xl64"]Reposses[/TD]
[TD="class: xl65"]Indefinito[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Reposses[/TD]
[TD="class: xl65"]Indefinito[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Terzi[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Quarti[/TD]
[TD="class: xl65"]Da definite[/TD]
[TD="class: xl64"]Reposses[/TD]
[TD="class: xl65"]Indefinito
[/TD]
</tbody>
Expected result inside the other worksheet with the originator file opened should be:
[TABLE="width: 357"]
<colgroup><col><col></colgroup><tbody>[TR]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
<tbody>
[TD="class: xl65, width: 131"]Stato
[/TD]
[TD="class: xl65, width: 226"]Luogo[/TD]
[TD="class: xl66"]Reposses[/TD]
[TD="class: xl67"]Indefinito[/TD]
[TD="class: xl66"]Reposses[/TD]
[TD="class: xl67"]Indefinito[/TD]
[TD="class: xl66"]Reposses[/TD]
[TD="class: xl67"]Indefinito[/TD]
[TD="class: xl66"]Reposses[/TD]
[TD="class: xl67"]Indefinito[/TD]
[TD="class: xl66"]Reposses[/TD]
[TD="class: xl67"]Indefinito[/TD]
[TD="class: xl66"]Reposses[/TD]
[TD="class: xl67"]Indefinito[/TD]
</tbody>
I hope it is clear,
Thank you guys,