I have a list including some survey scores (about 10.000 rows) as follows:
For example;
1.jpg
I want to achieve the following 4 things:
-I want to find the average of the survey points in 2020
-I want to find the average of the survey points in 2021
-I want to find the average of the scores of 2020 and 2021.
-The survey includes about 10.000 rows. So, how to automatize it? (It is very time consuming to manually find the teacher names in column A and find the averages for each of them)
Maybe we can add them as new columns as follows:
Attachment 763580
Please find the excel file in the attachment.
Bookmarks