Program is Excel VBA. Please no functions for min and max! Only nested loops!!!

When the user presses the Score button, your program will: . Use nested loops to input the scoring data from the worksheet. o The number of contestants can vary from 1 to 6, but the number of judges will always be5 o For each contestant: Determine the lowest (min) and highest (mcx) scores for each contestant, and output these scores to the min and max columns. Output the three middle scores. * If there are duplicate high or low scores, only remove one of them from consideration. In the example, Contestant 6's lowest score is 5 but two judges (Juage A and Judge E) entered a 5, so only one of these is removed. . * Output the total of the three middle scores to the Total c glumn Lowest and Highest score for each contestant Judges scores 2 Contestant Judge A min max 17.5 15 19 6.5 15.5 5 18.5 16 19 17 15.5 18.5 16.5 18.5 14 19.5 5 17 16 17 17.5 17.5 19.5 6.5 12 10 Contestant Middle scores 17.5 19 50 Score 12 13 19 17 7.5 18.5 50 Clear 53 15 17.5 47.5 6.5 When the user presses the Score button, your program will: . Use nested loops to input the scoring data from the worksheet. o The number of contestants can vary from 1 to 6, but the number of judges will always be5 o For each contestant: Determine the lowest (min) and highest (mcx) scores for each contestant, and output these scores to the min and max columns. Output the three middle scores. * If there are duplicate high or low scores, only remove one of them from consideration. In the example, Contestant 6's lowest score is 5 but two judges (Juage A and Judge E) entered a 5, so only one of these is removed. . * Output the total of the three middle scores to the Total c glumn Lowest and Highest score for each contestant Judges scores 2 Contestant Judge A min max 17.5 15 19 6.5 15.5 5 18.5 16 19 17 15.5 18.5 16.5 18.5 14 19.5 5 17 16 17 17.5 17.5 19.5 6.5 12 10 Contestant Middle scores 17.5 19 50 Score 12 13 19 17 7.5 18.5 50 Clear 53 15 17.5 47.5 6.5