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?
The definition of what is needed here is: ‘Run in X or more countries’ - So, I need to list the countries (in order of date completed - earliest first) and the relevant first event for that country, as well as the relevant date and time achieved.
I have populated (in yellow) what the results should be.
I thought I previously had this working, with the INDEX / AGGREGATE formulas that are present, but they are now not working (except for the first two). Each country should be unique.
Link to file here: parkrun - My parkrun Record - WORKING 2 - Reduced.xlsx
Thanks in advance!
Also posted on Excel Forum: INDEX AGGREGATE issue finding first instances with conditions
Would anyone please be able to help with calculations in my ‘All Completed Runs - C EC C’ worksheet, please?
The definition of what is needed here is: ‘Run in X or more countries’ - So, I need to list the countries (in order of date completed - earliest first) and the relevant first event for that country, as well as the relevant date and time achieved.
I have populated (in yellow) what the results should be.
I thought I previously had this working, with the INDEX / AGGREGATE formulas that are present, but they are now not working (except for the first two). Each country should be unique.
Link to file here: parkrun - My parkrun Record - WORKING 2 - Reduced.xlsx
Thanks in advance!
Also posted on Excel Forum: INDEX AGGREGATE issue finding first instances with conditions