Attention VBA/Excel experts

[alexenposadas]

Thank you for your prayers everyone!

[csterg]

This is too complex to handle... you probably need to code this.
Costas

[alexenposadas]

Thanks Costas, If you can think of another brother that might be able to help whther with Excel formulae or VBA, please let me know

[Manuel]

Hi.
I don't know if possible but maybe this could be done using sql, I mean, importing the excel file to an SQL Server instance and then using a case when statement to create the spected result, after that sould be just a matter of exporting back to excel.
Could you upload the file so we can see it?


Blessings,
Manuel.