INDEX AGGREGATE issue finding first instances with conditions

[ollyhughes1982]

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

 

[ollyhughes1982]

You're welcome & thanks for the feedback.

If you ever take up parkrunning (you might already?), you know where to find the ultimate results tracker!