Forum Discussion
gather data in different worksheets
Hello, I attached a file to make it easier to explain and hopefully to find a solution. In the file there is a tab individual performance and working hours. I would like to gather from the ta...
I prepared two files for you.
V2 file: using formula "AVERAGEIFS" to do the averaging. But it requires that the columns for person are correspondence.
V3 file: change the structure of the data and then using a pivot table to demonstrate