Find Highest six Numbers from a List

[mlmrob]

Guys I have a spreadsheet with speed figures for racehorses for the years 2022-2023.
At the minute I am using the filter to find each horse and manually writing the last six speed figures of the horse and entering those against the horse if it is running that day.

I want to take the best six speed figures for a horse from column N
and place them in six cells adjacent to their name in R column. The P to R column is the names of the horses running that day with their racetime and the track the are running at.

The link to the spreadshheet is

FLAT2020_2023.xlsx

Microsoft Excel Workbook

1drv.ms

Thanks

Rob

 

[Fluff]

How about

=TOROW(TAKE(FILTER($N$2:$N$300000,$I$2:$I$300000=TEXTBEFORE(R2," (",,,1),""),6))

 

[mlmrob]

Firstly, thank you for the prompt reply and secondly, wow, that is fantastic. Very much appreciated Fluff.

 

[Fluff]

You're welcome & thanks for the feedback.