Hi
I want to auto rank the results of a car sprint. The cars run over set distance and the time for each car is recorded. This is called Overall Rank. I have this auto sorting by using "Match" and "Index:. The cars run in groups called classes.( A,B, C, D etc) This the part I am having problems with. I can rank them by using "Sumproduct ", but am unable to auto sort them.
I am using Excel 2019 with does not have the Sort Function
The idea is to have a Dashboard sheet which stays in car Number order as an input sheet and have one sheet which has the results sorted by Overall Rank and an other sheet which is sorted to Class Rank.
Bookmarks