to sort hdcp figures in golf results using excel 2007

[Debes7]

HI, Please help me write a formula to sort the 10 lowest scores out of the last 20 games and either mark them or copy in the next col.
I can add and average the result.

The real and complete way to calculate HDCP is
5 or 6 games Lowest 1
7 or 8 games Lowest 2
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​

​

 

[Peter_SSs]

Welcome to the MrExcel board!

We don't know anything about your layout, but see if this helps.
Columns D:W would be your records of the last 20 scores (weekly?)
Columns AK:AL hoses the table to look up how many numbers to retrieve
Column B counts how many scores there have been for the player over the last 20 possible competitions. Formula copied down.
Column C uses the AK:AL table to calculate how many scores to retrieve for the player. Formula copied down.
Y1:AH1 has 1-10 entered manually
Formula in Y2 is copied across to AH2 and down.

Post back with more details &/or sample data if this is not what you need. My signature block below has a link for how to post screen shots like this.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL
1		Count	Num																						1	2	3	4	5	6	7	8	9	10			0	0
2	Player 1	20	10	77	85	75	94	70	99	97	84	74	93	78	95	88	87	70	94	92	75	81	70		70	70	70	74	75	75	77	78	81	84			5	1
3	Player 2	10	3	94	79			86	84		71	91		71				72	90			94			71	71	72										7	2
4	Player 3	18	8	84	84	92	74	70	78	98	81	98	72		72	91	93	80	92	72	75		91		70	72	72	72	74	75	78	80					9	3
5																																					11	4
6																																					13	5
7																																					15	6
8																																					17	7
9																																					18	8
10																																					19	9
11																																					20	10
Golf

 

[Fluff]

Cross posted https://www.excelforum.com/excel-fo...f-results-using-excel-2007-a.html#post4875345

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Debes7]

Cross posted https://www.excelforum.com/excel-fo...f-results-using-excel-2007-a.html#post4875345

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Sorry about that
couldn't load your VBHTML Maker probably because of firewall or Anti virus, anyway I tried for a few hours many diff ways and than quit.
If you want to see example of my excel file Please refer to:

https://www.excelguru.ca/forums/sho...-out-of-20-using-excel-2007&p=36628#post36628

But it seems that you already know that.
In any case I thank you very much for your time and I will make with what I have for now.
Thanks again
Denis