debes7
New member
- Joined
- Apr 1, 2018
- Messages
- 12
- Reaction score
- 0
- Points
- 0
- Location
- Longueuil, QC Canada
- Excel Version(s)
- 2007
HI, Please help me write a formula
to sort the 10 lowest scores out of the last 20 entered by date and either mark them or copy in the next col. So they can be added.
I can add and average the result.
The real and complete way to calculate HDCP is
5 or 6 games, sort the Lowest 1
7 or 8 games, sort the Lowest 2 and so forth,
9 or 10 Lowest 3
11 or 12 Lowest 4
13 or 14 Lowest 5
15 or 16 Lowest 6
17 Lowest 7
18 Lowest 8
19 Lowest 9
20 games Lowest 10
But if that's too complicated, I can live with 10 best of 20.
Thanks
to sort the 10 lowest scores out of the last 20 entered by date and either mark them or copy in the next col. So they can be added.
I can add and average the result.
The real and complete way to calculate HDCP is
5 or 6 games, sort the Lowest 1
7 or 8 games, sort the Lowest 2 and so forth,
9 or 10 Lowest 3
11 or 12 Lowest 4
13 or 14 Lowest 5
15 or 16 Lowest 6
17 Lowest 7
18 Lowest 8
19 Lowest 9
20 games Lowest 10
But if that's too complicated, I can live with 10 best of 20.
Thanks