Hi
I plan on having a master tab that I will continue to add data to over time. I'm looking to create a summary tab that show the most recent 3 week's average per employee. Please see example data below. I provided four dates below, but would only want the average to be the three most recent weeks.
Thank you!
EXAMPLE OF MASTER DATA SOURCE TAB
EXAMPLE OF DESIRED OUTPUT ON ANOTHER TAB:
I plan on having a master tab that I will continue to add data to over time. I'm looking to create a summary tab that show the most recent 3 week's average per employee. Please see example data below. I provided four dates below, but would only want the average to be the three most recent weeks.
Thank you!
EXAMPLE OF MASTER DATA SOURCE TAB
Name | Count | Date |
Dave | 6 | 1/1/2021 |
Dave | 11 | 2/1/2021 |
Dave | 17 | 3/1/2021 |
Dave | 20 | 4/1/2021 |
Tim | 4 | 1/1/2021 |
Tim | 23 | 2/1/2021 |
Tim | 10 | 3/1/2021 |
Tim | 12 | 4/1/2021 |
Kate | 24 | 1/1/2021 |
Kate | 12 | 2/1/2021 |
Kate | 10 | 3/1/2021 |
Kate | 6 | 4/1/2021 |
EXAMPLE OF DESIRED OUTPUT ON ANOTHER TAB:
Name | Most recent 3 weeks average |
Dave | 16 |
Tim | 15 |
Kate | 13 |