# Thread: to sort 10 lowest figures out of 20 using excel 2007

1. ## to sort 10 lowest figures out of 20 using excel 2007

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

2. Hi and welcome
please post a small sample sheet with some data and expected results ( Click "Go advanced - Manage attachments). Thx

3. ## Sort smallest entries Max(10) out of last date entered 20 items

Sort col I to results in col K

4. I am not sure I understand. You have six results and have picked out the lowest four - that's different to what you seem to be saying above. However, try this as a starting point in K13 copied down:

=IF(I13<SMALL(\$I\$13:\$I\$18,5),I13,"")

5. Originally Posted by AliGW
I am not sure I understand. You have six results and have picked out the lowest four - that's different to what you seem to be saying above. However, try this as a starting point in K13 copied down:

=IF(I13<SMALL(\$I\$13:\$I\$18,5),I13,"")
Sorry about that, there should be only one result in K17 picked as 1 in 6 entries, that was a manual test sheet and forgot to remove the extras.
Can you elaborate the formular to include the balance of the instructions up to:

After more than 20 entries
The last 10 more recent (date entries) out of the total should be picked
thank you very much
Denis

6. Your post does not comply with our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

This query has been posted on at lease three forums with no links.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•