SORT(FILTER Function - Need to sort by adjacent column

[ollyhughes1982]

Hi all,

Re the below screenshot:

I have a working worksheet, which works and calculates what I want. However, I would just rather that it sorted by column A, rather than by the name of the parkrun (column C), where the main function is calculated.

Is there a way I can add something into the function in column C, so that the results sort by column A or B (either is fine)?

I have included a link to file here (it’s relatively small and should open up quickly): Sort By Distance Issue.xlsx

Thanks in advance,

Olly.

 

[Fluff]

Try clearing columns A:C & putting this in A4

=LET(f,FILTER('parkrun Reader Dump'!B3:AW5002,('parkrun Reader Dump'!N3:N5002=1)*('parkrun Reader Dump'!O3:O5002=1)*('parkrun Reader Dump'!P3:P5002=1)*('parkrun Reader Dump'!AP3:AP5002<>1)*('parkrun Reader Dump'!AV3:AV5002>0)*('parkrun Reader Dump'!AV3:AV5002<78)),SORT(INDEX(f,SEQUENCE(ROWS(f)),{47,48,1}),1))

PS you currently have your distances in the wrong column, this will correct that.

 

[ollyhughes1982]

Try clearing columns A:C & putting this in A4

=LET(f,FILTER('parkrun Reader Dump'!B3:AW5002,('parkrun Reader Dump'!N3:N5002=1)*('parkrun Reader Dump'!O3:O5002=1)*('parkrun Reader Dump'!P3:P5002=1)*('parkrun Reader Dump'!AP3:AP5002<>1)*('parkrun Reader Dump'!AV3:AV5002>0)*('parkrun Reader Dump'!AV3:AV5002<78)),SORT(INDEX(f,SEQUENCE(ROWS(f)),{47,48,1}),1))

PS you currently have your distances in the wrong column, this will correct that.

Well spotted re having them the wrong way around! Thanks, I'll try this now

 

[ollyhughes1982]

Yes, that worked perfectly.

Thanks so much, brilliant as always!

 

[Fluff]

You're welcome & thanks for the feedback.