Forum Discussion
Viral Patel
Feb 03, 2018Copper Contributor
Need help to populate table from tally table
Hi
I am trying create a table that populate the analysis table from the Tally table but It sounds like a complicated formula.
I have attached the excel sheet with how I would like the analysis sheet being completed.
Please could you help me.
Viral
I am trying create a table that populate the analysis table from the Tally table but It sounds like a complicated formula.
I have attached the excel sheet with how I would like the analysis sheet being completed.
Please could you help me.
Viral
5 Replies
Sort By
- Haytham AmairahSilver Contributor
Viral,
You don't have to use any complex formula if you got an alternative and easier solution!
You can use the PivotTable which is powerful, easy, and time saver data analysis tool!
I've updated your workbook with the solution!
- Viral PatelCopper ContributorHi
Thanks for the reply however I don't want to use a pivot table only formula.- Haytham AmairahSilver Contributor
Ok, I've updated the workbook with a formula solution!
Anyway, it's not as complex as you think!
Please find the attached file.