455,491 Members | 1,868 Online
Need help? Post your question and get tips & solutions from a community of 455,491 IT Pros & Developers. It's quick & easy.

# Getting three highest values

 P: n/a Hi there, I have a table with sporting events and the scores per event for each member. Each member partakes in at least 6 events per year. Question 1, how can I find and sum the three higest scores per member for a year and get a total. (this total will determine the ranking of the member for the event) Question 2, How can I exclude members from question 1 who has not participated in at least 4 activities per event. Example: Player 1 plays 6 cricket matches for the year. He scores 11, 55, 37, 0, 48 and 8 respectively for each match. I need to add the three best scores, 55 + 37 + 48 = 140 (this should be done for each player and then based on the sumed value, their ranking is determined. Player 2 plays only 3 matches. He scores 75, 30 and 29. He did not play a minimum of 4 matches and therfor does not qualify. Any ideas on how to do this. Thanks Elmo Nov 13 '05 #1