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.
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.