INDEX MATCH SMALL likely function to find nth occurrences in a column

[ollyhughes1982]

Hi,

Please see attached link, where I am trying to find the first 10 unique events that begin with the letter 'S' as well as the dates on which they were first completed. I need to search the range C3:C2002 in the 'All Completed Runs' worksheet and return the relevant events and dates in columns B and C of the 'All Completed Runs - Ssssnakes' worksheet.

I thought that some sort of Index Match or Index Small function would do this, but I am really struggling to find a solution, if anyone might be able to help.

parkrun - My parkrun Record (Ssssnakes).xlsx

Microsoft Excel Workbook

1drv.ms

Thanks!

Also asked on Excel Forum: INDEX MATCH SMALL likely function to find nth occurrences in a column

 

[Fluff]

Glad we could help & thanks for the feedback