ollyhughes1982
Well-known Member
- Joined
- Nov 27, 2018
- Messages
- 718
- Office Version
- 365
- Platform
- MacOS
Hi all,
Would anyone please be able to help with calculations in my ‘All Completed Runs - I Alphabet’ worksheet, please? In my ‘All Completed Runs - Summary’ worksheet (cell B147) I need a count of the number of different events (venues) in each different country I have run in so far. The ‘All Completed Runs - Alphabet’ worksheet works in a very similar way.
The definition of what is needed here is: ‘Complete events (venues) that start with each letter of the alphabet (excluding X), that are not in my home country (United Kingdom).’
I have populated in the separate worksheet (in yellow) what the results should be.
I think this will be some sort of unique filter type solution for the ‘All Completed Runs - I Alphabet’ worksheet and possibly a sum product type solution for cell B147 of the ‘All Completed Runs - Summary’ worksheet, as has been the case in other similar areas of my workbook.
Link to file here: International Alphabeteer.xlsx
Thanks in advance!
Would anyone please be able to help with calculations in my ‘All Completed Runs - I Alphabet’ worksheet, please? In my ‘All Completed Runs - Summary’ worksheet (cell B147) I need a count of the number of different events (venues) in each different country I have run in so far. The ‘All Completed Runs - Alphabet’ worksheet works in a very similar way.
The definition of what is needed here is: ‘Complete events (venues) that start with each letter of the alphabet (excluding X), that are not in my home country (United Kingdom).’
I have populated in the separate worksheet (in yellow) what the results should be.
I think this will be some sort of unique filter type solution for the ‘All Completed Runs - I Alphabet’ worksheet and possibly a sum product type solution for cell B147 of the ‘All Completed Runs - Summary’ worksheet, as has been the case in other similar areas of my workbook.
Link to file here: International Alphabeteer.xlsx
Thanks in advance!