Hi all,
Would anyone please be able to help with calculations in my ‘All Completed Runs - Piper’ worksheet, please?
The definition of what is needed here is: ‘Run at 5 different events (venues) in each of 5 different countries (pC-Index of 5).’
I have populated in the separate table below the main table (in yellow) what the results should be.
I think this will be some sort of unique filter or index match type solution, as has been the case in other similar areas of my workbook.
I have now added a helper column (the last column in the 'All Completed Runs' worksheet) which lists the instance of each country and has helped me solve some of my other queries. I'm still stuck on this one though. I am struggling to find a way to specify finding the first country and then the first five events for that country, then the first five for the second country and then the first 5 for the third country and so on. I need to do it for the first five countries. Up-to-date link is here:
https://drive.google.com/open?id=1ck...6rWstvwRWU3lsZ
Thanks in advance!
Also posted on Mr Excel: https://www.mrexcel.com/board/thread...tions.1131891/
Bookmarks