Create the Custom List

There is no custom sort in Numbers. You can do this, though:

Table 2 is your custom sort order

Table 1 column C formula is =XMATCH(B,Table 2::A,0)

Sort ascending/descending on column C

If there are values in Table 1 that are not in your "sort order" table, they will get error triangles. Similarly, if Table 1 has empty rows but the "sort order" table has none, the empty rows will get error triangles.

If you don't like all the extra numbers in the table you can set the text color to white.

You can put the 1,2,3,4 , etc,. in a separate 'sort' column next to the column with the original data and sort on that new 'sort' column.

SG