Missing INDEX AGGREGATE criteria

[ollyhughes1982]

Hi all,

I have an issue with my Excel file formula, missing a couple criteria. The cell B49 should display 'Trelai Park parkrun, United Kingdom' - 14K Away. At the moment it is picking up junior events and also events that I have already completed, these should both be excluded.

What the cell should do, in addition to what it already does correctly is, display the above, but only if the following two conditions are met:
- It is not a junior event (i.e. blank in column ‘V’ of the 'Miscellaneous Data - AP' worksheet)
- Has not yet been completed (i.e. blank in column ‘K’ of the 'Miscellaneous Data - AP' worksheet)

The result should be Trelai Park, which is 14K away from my home event of Coed Cefn-pwll-du.

Link: parkrun - My parkrun Record - WORKING.xlsx

Thanks in advance!

 

[KRice]

Your link gives a "Couldn't Open the Workbook" error, citing an issue with Excel Online and exceeding the 5 MB file size limit.

 

[ollyhughes1982]

Your link gives a "Couldn't Open the Workbook" error, citing an issue with Excel Online and exceeding the 5 MB file size limit.

Apologies. Size is now ok.
Link: parkrun - My parkrun Record - WORKING.xlsx