Show highest 50% of results

[adurham22926192]

I making and Irish dance score system and I need a formula to show the highest 50% of the results in a separate coloumn.

Column A: Competitor No (101,102,etc)
Column B: First Score (87,82,etc)
Column C: Second Score (88, 84, etc)
Column D: Total Score (=sum)

In Column F I want it to show top 50% of the competitor numbers that have the highest total score and I want their total score to be along side their number in Column G

Please help me out, thanks so much

 

[Peter_SSs]

Is this what you mean?

A_MrExcel.xlsm
	A	B	C	D	E	F	G
1	No			Total		No	Total
2	101			113		111	178
3	102			171		106	176
4	103			121		109	176
5	104			147		102	171
6	105			167		105	167
7	106			176
8	107			150
9	108			156
10	109			176
11	110			155
12	111			178
Top 50%

Cell Formulas
Range	Formula
F2:F12	F2	=IF(G2="","",INDEX(A:A,AGGREGATE(15,6,ROW(A$2:A$12)/(D$2:D$12=G2),COUNTIF(G$2:G2,G2))))
G2:G12	G2	=IF(ROWS(G$2:G2)>ROWS(A$2:A$12)/2,"",AGGREGATE(14,6,D$2:D$12,ROWS(G$2:G2)))

 

[adurham22926192]

Yeah thanks so much. How would I do 40% instead of 50%

 

[Peter_SSs]

Yeah thanks so much. How would I do 40% instead of 50%

Change the G2 formula like this

=IF(ROWS(G$2:G2)>ROWS(A$2:A$12)*40%,"",AGGREGATE(14,6,D$2:D$12,ROWS(G$2:G2)))