Forum Discussion
Spreadsheet advise - drone race
Good. I'm glad it worked for you.
Those new Dynamic Array functions are amazing. I've been having a ball seeing what they can do...your situation was one that was fun working out. In all candor, it took me a while to figure out the nested SORT as the way to do the two level sorting. There is a SORTBY function that will work as well, but I couldn't make it work with the FILTER function.
Maybe another one of the Excel Microsoft MVPs will come by and enlighten us both.
I'm hoping you have the most recent version of Excel, the one that includes the FILTER and SORT dynamic array functions. Hoping that because they are what I used to resolve your situation.
First, though, I reorganized your basic table so that it's an Excel Table as shown here:
That done, I nested the FILTER function in two (!) SORT functions to do the sorting you wanted
=SORT(SORT(FILTER(Table1[[Round]:[Times]],Table1[Pilot]=F$1),3,1),2,-1)
And that produced these results.
mathetes I would like to say thank you very much! I have updated my Excel and that is exactly what I needed, the spreadsheet works perfect. I truly appreciate your advise, thank you for your time.
I, honestly, thought it was impossible to do this task in such a clear and concise manner.
Good. I'm glad it worked for you.
Those new Dynamic Array functions are amazing. I've been having a ball seeing what they can do...your situation was one that was fun working out. In all candor, it took me a while to figure out the nested SORT as the way to do the two level sorting. There is a SORTBY function that will work as well, but I couldn't make it work with the FILTER function.
Maybe another one of the Excel Microsoft MVPs will come by and enlighten us both.