SEQUENCE() function likely needed

[ollyhughes1982]

Hi,

I have the worksheet (‘All Completed Runs - NENDY’) shown in the image (attached) 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.

Thanks in advance!

Also posted on MR. EXCEL: https://www.mrexcel.com/board/thread...eeded.1211393/

Olly.NENDY by Next 50.jpg

[TMS]

Change SEQUENCE(ROWS(f)) to SEQUENCE(50)

[ollyhughes1982]

Great. Thanks.

[TMS]

You're welcome.