INDEX curly bracket issue likely

[ollyhughes1982]

Hi.

I have this formula, which identifies the closest events to me from a table that contains a list of distances in column I:

=IFERROR(LET(f,FILTER('parkrun Reader Dump'!B3:J10002,('parkrun Reader Dump'!K3:K10002="")*('parkrun Reader Dump'!N3:N10002=1)*('parkrun Reader Dump'!O3:O10002=1)*('parkrun Reader Dump'!P3:P10002=1)*('parkrun Reader Dump'!AS3:AS10002<>1)*('parkrun Reader Dump'!I3:I10002<200)),SORT(INDEX(f,SEQUENCE(50),{8,9,1}),1)),"")

This works perfectly, but I now want to do the same, but pick up slightly different columns (the one for volunteering (R)), but it isn’t working for me. I have put below what I think it should be, but isn’t working:

=IFERROR(LET(f,FILTER('parkrun Reader Dump'!B3:J10002,('parkrun Reader Dump'!R3:R10002="")*('parkrun Reader Dump'!N3:N10002=1)*('parkrun Reader Dump'!O3:O10002=1)*('parkrun Reader Dump'!AS3:AS10002<>1)*('parkrun Reader Dump'!I3:I10002<200)),SORT(INDEX(f,SEQUENCE(50),{8,9,1}),1)),"")

This is what I amended:

• I swapped K to the relevant column R
• I removed the reference to the P column (as it isn’t needed for this one)

I’m guessing it’s the part in curly brackets ({8,9,1}) that it wrong, but I don’t know what that is doing, so am not sure how it would be amended.

Thanks in advance!

Olly.

 

[ollyhughes1982]

Probably just pure coincidence, if it is actually working.

Yes, you have inadvertently just found an issue with the original one! I just tested it on the original one, by amending to your way, and it is now working correctly. I thought it was previously, but I can now see ones that it had indeed been missing out. Thanks again, this has been a big help! I hadn't bothered you for at least a few weeks!

 

[Fluff]

Glad to help & thanks for the feedback.