Problem to show result competitors-name

E

Eddietje

New Member
Joined
Aug 26, 2022
Messages
4
Office Version
  1. 2010
Platform
  1. Windows
Hello everybody, I have a little problem in an Excel sheet named "Competition". An exemple here under :

RESULTS COMPETITION
Nr.NameScores
CompetitorCometitorResult
1Jan met de pet1
2Lowieke Staal4
3Kees Oranje10
4Lodewie Wittekop2
5Doortje van 't café5
6Wies De Kaarter10
7Schele Vanderlinde7
8Blauwe Geschelpte3
9Zotten Door8
10Rappe Jef6
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.
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Sort by date Sort by votes
Hi & welcome to MrExcel.
How about
Fluff.xlsm
ABC
1RESULTS COMPETITION
2
3Nr.NameScores
4CompetitorCometitorResult
5
61Jan met de pet1
72Lowieke Staal4
83Kees Oranje10
94Lodewie Wittekop2
105Doortje van 't café5
116Wies De Kaarter10
127Schele Vanderlinde7
138Blauwe Geschelpte3
149Zotten Door8
1510Rappe Jef6
16
17WINNER(S)
183Kees Oranje
196Wies De Kaarter
20  
21  
22  
23  
Main
Cell Formulas
RangeFormula
A18:B23A18=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))),"")
 
Upvote 0
Solution
I like to save my worksheet by using F-6 button. Is this possible and how can I do that ?
 
Upvote 0
What has this got to do with your original question?
 
Upvote 0
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 ?
 
Upvote 0
As that is a totally different question, it needs a new thread. Thanks
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,216,500
Messages
6,131,016
Members
449,615
Latest member
Nic0la

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top