Forum Discussion
Sort by location and top 5 ?
I have a list of location, races and results. I am looking to filter the results to only show the top 3 fastest times per location and event. For example: Column A = New York, Boston, Kansas City et...
=DROP(REDUCE("",SEQUENCE(ROWS(UNIQUE(Tabelle6[[Location]:[Heat]]))),LAMBDA(x,y,VSTACK(x,TAKE(SORT(FILTER(Tabelle6,(Tabelle6[Location]=INDEX(CHOOSECOLS(UNIQUE(Tabelle6[[Location]:[Heat]]),1),y))*(Tabelle6[Heat]=INDEX(CHOOSECOLS(UNIQUE(Tabelle6[[Location]:[Heat]]),2),y))),3,1),3)))),1)
With Office 365 or Excel for the web you can use this formula along with a dynamic table to spill the results dynamically.