Forum Discussion

Copper Contributor

Mar 13, 2024

Drag and Fill Problem

Hello, I want to calculate the average number of 7 numbers that I tracked for each day of a week. In the next row there should be the average of the next 7 numbers of the next week. And I want th...

excel

Formulas and Functions

Detlef_Lewin

Silver Contributor

Mar 13, 2024

oskar14

Better use this data structure. Then it is a simple pivot table.

oskar14

Copper Contributor

Mar 13, 2024

Thanks a lot but how do I actually create this pivot table for my specific purpose?

Detlef_Lewin
Silver Contributor
Mar 13, 2024
oskar14
https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576
And a million more tutorials.
- oskar14
  Copper Contributor
  Mar 13, 2024
  Detlef_Lewin Thanks!