ollyhughes1982
Well-known Member
- Joined
- Nov 27, 2018
- Messages
- 677
- Office Version
- 365
- Platform
- MacOS
Hi all,
Would anyone please be able to help with calculations in my ‘All Completed Runs - C EC C’ worksheet, please? In my ‘All Completed Runs - Summary’ worksheet (cells B136:B140) I need a count of the number of different countries run in so far (limited to the maximum for each category).
The definition of what is needed here is: ‘Run in X or more countries’
I have populated in the separate worksheets (in yellow) what the results for each should be. At the moment I have only done 4 different countries, so the same results are in each at the moment.
I think this will be some sort of unique filter type solution for the ‘All Completed Runs - C EC C’ worksheet and subsequent 4 worksheets and possibly a sum product type solution for cells B136-140 of the ‘All Completed Runs - Summary’ worksheet, as has been the case in other similar areas of my workbook.
Link to file here: Castle Classes.xlsx
Thanks in advance!
Would anyone please be able to help with calculations in my ‘All Completed Runs - C EC C’ worksheet, please? In my ‘All Completed Runs - Summary’ worksheet (cells B136:B140) I need a count of the number of different countries run in so far (limited to the maximum for each category).
The definition of what is needed here is: ‘Run in X or more countries’
I have populated in the separate worksheets (in yellow) what the results for each should be. At the moment I have only done 4 different countries, so the same results are in each at the moment.
I think this will be some sort of unique filter type solution for the ‘All Completed Runs - C EC C’ worksheet and subsequent 4 worksheets and possibly a sum product type solution for cells B136-140 of the ‘All Completed Runs - Summary’ worksheet, as has been the case in other similar areas of my workbook.
Link to file here: Castle Classes.xlsx
Thanks in advance!