We need a formula(s) that can reflect a person's position compared to his team in different categories, e.g. 1st place(1), 2nd place(3), 3rd place(3) forth place(4), etc...
In our sample file we show that GOLF won the 1st place for COUNT category, and MAURICE was 10th place.
How could we automatically have all of these results displayed using the data from the top table?
Thanks.
In our sample file we show that GOLF won the 1st place for COUNT category, and MAURICE was 10th place.
How could we automatically have all of these results displayed using the data from the top table?
Thanks.