ollyhughes1982
Well-known Member
- Joined
- Nov 27, 2018
- Messages
- 677
- Office Version
- 365
- Platform
- MacOS
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.
Thanks!
Also asked on Excel Forum: INDEX MATCH SMALL likely function to find nth occurrences in a column
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.
Thanks!
Also asked on Excel Forum: INDEX MATCH SMALL likely function to find nth occurrences in a column