SEQUENCE() function likely needed

[ollyhughes1982]

Hi,

I have the worksheet (‘All Completed Runs - NENDY’) shown in the image (below) and wondered if anyone might be able to help with slight tweak of what is displayed, please? At the moment, I have it displaying all of the Events (Venues) that I haven’t yet ran at, within a 200K radius. However, I’d like to slightly tweak this as it's displaying more results than I'd like; I'd rather just display the next 50 nearest Events (Venues) that I haven't yet ran at, instead.

The current formula is as below:

=IFERROR(LET(f,FILTER('parkrun Reader Dump'!B3:J5002,('parkrun Reader Dump'!K3:K5002="")*('parkrun Reader Dump'!N3:N5002=1)*('parkrun Reader Dump'!O3:O5002=1)*('parkrun Reader Dump'!P3:P5002=1)*('parkrun Reader Dump'!AS3:AS5002<>1)*('parkrun Reader Dump'!I3:I5002<200)),SORT(INDEX(f,SEQUENCE(ROWS(f)),{8,9,1}),1)),"")

I’m guessing that I need to remove the ‘*(‘parkrun Reader Dump'!I3:I5002<200)’ part and add in some sort of extra ‘SEQUENCE()’ function, but I haven’t been able to get it to work so far.

I have linked the file here (it’s small and will open quickly): NENDY by Next 50.xlsx

Thanks in advance!

Olly.

Also listed on Excel Forum: SEQUENCE() function likely needed

 

[Fluff]

Just replace ROWS(f) with 50

 

[ollyhughes1982]

Just replace ROWS(f) with 50

Great. Thanks!

 

[Fluff]

You're welcome & thanks for the feedback.