Sorting question: Probably not too common

  • Thread starter Thread starter esq
  • Start date Start date
E

esq

Hello! I'm wondering if anybody can offer me some help here (or if thi
is possible at all).

Basically I want to sort rows in a spreadsheet to match the sequence o
another chunk of rows.

ie:

If one block of rows looks like:
This | 5.46 | Yes
That | 9.99 | No
Other | 0.99 | No

and another looks like:
Other | 0.99 | No
This | 5.46 | Yes
That | 9.99 | No


Is it possible to sort the first rows into those of the 2nd block b
the names in the far left column (for example)?
I apologize if this is still unclear, I will try harder.

Thank you
 
esq,

You can make a Custom List (Tools - Options - Custom lists) from the data in
the column, then specify that Custom List when you sort (Data - Sort -
Options - First key sort order).
 
Back
Top