Hello.

I am trying to create a sheet that averages the last 5 scores.

My idea is to have the input cell at A1, and the average cell at A7.

When a value is entered into A1, it appears in A2.

When a second value is entered into A1, it appears in A2 and the value in A2 moves to A3.

When a third value is entered into A1, it appears in A2, the value in A2 moves to A3 and the value in A3 moves to A4, and so on.

All the while, the value in A7 changes to represent the new mean.

Once A6 is full, a new A1 entry will cause the A6 number to disappear, as the value is now to old and no longer of any use.

Is this possible in excel?

Cheers

​Hello. I am trying to create a sheet that averages the last 5 scores.My idea is to have the input cell at A1, and the average cell at A7.When a value is entered into A1, it appears in A2.When a second value is entered into A1, it appears in A2 and the value in A2 moves to A3.When a third value is entered into A1, it appears in A2, the value in A2 moves to A3 and the value in A3 moves to A4, and so on.All the while, the value in A7 changes to represent the new mean.Once A6 is full, a new A1 entry will cause the A6 number to disappear, as the value is now to old and no longer of any use.Is this possible in excel?  Cheers  Read More

​