We are having a sales contest this month. The teams (Houses) entered their numbers and we are ready to Identify the winners for 1st, 2nd and 3rd place.
I was able to identify the 1st place score (Highest Score) using the MAX function and the name of the House (Top Team) with the JOIN function.
BUT, I cannot identify the subsequent scores for 2nd and 3rd place. please help me...