Problem to show result competitors-name

[Eddietje]

Hello everybody, I have a little problem in an Excel sheet named "Competition". An exemple here under :

RESULTS COMPETITION
Nr.	Name	Scores
Competitor	Cometitor	Result
1	Jan met de pet	1
2	Lowieke Staal	4
3	Kees Oranje	10
4	Lodewie Wittekop	2
5	Doortje van 't café	5
6	Wies De Kaarter	10
7	Schele Vanderlinde	7
8	Blauwe Geschelpte	3
9	Zotten Door	8
10	Rappe Jef	6
WINNER(S)

My problem : As soon as one or more competitors reached a score of 10 ik like to see automatic appear there number and name under the word WINNER(S), but I don't know the function or formula that I need to use therefor. Please is there someone who can help me to solve my problem ? Many thanks.

 

[Fluff]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	A	B	C
1	RESULTS COMPETITION
2
3	Nr.	Name	Scores
4	Competitor	Cometitor	Result
5
6	1	Jan met de pet	1
7	2	Lowieke Staal	4
8	3	Kees Oranje	10
9	4	Lodewie Wittekop	2
10	5	Doortje van 't café	5
11	6	Wies De Kaarter	10
12	7	Schele Vanderlinde	7
13	8	Blauwe Geschelpte	3
14	9	Zotten Door	8
15	10	Rappe Jef	6
16
17	WINNER(S)
18	3	Kees Oranje
19	6	Wies De Kaarter
20
21
22
23
Main

Cell Formulas
Range	Formula
A18:B23	A18	=IFERROR(INDEX(A$6:A$15,AGGREGATE(15,6,(ROW($C$6:$C$15)-ROW($C$6)+1)/($C$6:$C$15=10),ROWS(A$18:A18))),"")

 

[Eddietje]

I like to save my worksheet by using F-6 button. Is this possible and how can I do that ?

 

[Fluff]

What has this got to do with your original question?

 

[Eddietje]

Sorry Fluff, i just saw now that i had to remark the flow when my problem is solved and that's what You've done. You solved my problem and therefor I'm very greatfull ! Now, I have another question and this has nothing to do with the problem before. So, now i wonder how I can save a worksheet by using the F-6 or another function key. Can You help me again with my problem please ?

 

[Fluff]

As that is a totally different question, it needs a new thread. Thanks