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 https://support.office.com/en-us/article/Create-a-PivotTable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576 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.