I have an excel on ‘Staff List’ which shows the people who have participated in the survey everyday, separated by different daily tabs.
I have another excel ‘Tabulation’ which will calculate the % of people who have participated in the survey by extracting the count from ‘Staff List’, but the columns would add on by day as it would be computed daily.
There is a ‘Template’ tab in the Tabulation excel file where the data would be fixed and the output I want would look like the tab ‘Output’ in the Tabulation excel file.
I did a very draft workflow but I can’t figure it out because there are so many requirements.
Staff List - Test (1).xlsx (16.2 KB) Tabulation.xlsx (12.1 KB) Test.xaml (7.1 KB)