Manual Best Averages of a Session

[michaelcmelton]

I'm working on an excel spreadsheet to track my progress on my 3x3, so how do I manually calculate my best averages within a session? Say for instance:

1. 38.75
2. 45.6
3. 32.45
4. 37.42
5. 34.54
6. 36.73
7. 31.45
8. 34.54
9. 32.12
10. 30.43
11. 35.43
12. 34.25
13. 33.14

Are times for a session, how do I manually calculate the best average of 5?

 

[Bindedsa]

I'm not expert, but the way I would do is just get each average of 5 in the next column EG: =(Sum(A1:A5)-Min(A1:A5)-(A1:A50))/3 and then at the bottom of the of that column =Min(B1:B13).

There is probably an easier way to do this, but anyway i don't see the point? Why not just export them into QQ.