SORTBY problems

[ollyhughes1982]

Hi,

I am attempting to SORTBY function, but don’t seem to be able to get it to work. Please could someone show me where I am going wrong.

The current formula I am using is:

=IF(A2="","",IFERROR(SORTBY(B2:B10001,'Sort List'!A2:A10001),""))

In column D of the ‘Unique Character Extraction’ worksheet, I am trying to sort (spilling down) the non-blank cells from the range B2:B10001t. I have set the order I would like them sorted by in A2:A69 of the second worksheet (‘Sort List’), but it doesn’t seem to be working. For some reason it is showing ‘8’ first ands then a seemingly random order after that, including 0 values. It should sort as I have set in the second worksheet. I assumed SORTBY was the correct function for this, but doesn’t seem to be working.

Any help much appreciated!

I’ve also added a link to the file: parkrun - Extract Unique Characters.xlsx

Thanks in advance!

Olly.

 

[Cubist]

This is in your column D.

=IF(B2="","",TOCOL(SORTBY(B2:B10001,MATCH(B2:B10001,'Sort List'!A2:A10001,0)),3))

 

[ollyhughes1982]

This is in your column D.

=IF(B2="","",TOCOL(SORTBY(B2:B10001,MATCH(B2:B10001,'Sort List'!A2:A10001,0)),3))

Oh, you edited the online version? Thanks

 

[ollyhughes1982]

This is in your column D.

=IF(B2="","",TOCOL(SORTBY(B2:B10001,MATCH(B2:B10001,'Sort List'!A2:A10001,0)),3))

This did the job, thanks