Thanks, the issue is that the list is so long that to create a helper colomn
would take as long or longer than just manually arranging the minority of
rows which need to be sorted by the real word. Thanksk for your response.

"NewsNet" wrote:

Create a helper column that contains the real word, then sort that.
You could populate this with a VLOOKUP of desired value. If the VLOOKUP
errors (no real word applicable) use the word in the column.

NickHK


"sinkhole" ...
Thanks, but the list is so long, that I'd like to institute a sorting
order
that would take care of the post process automatically rather than me
doing
it all manually.

Thanks for your reply.

"crazybass2" wrote:

Sink,

I think I'd do a post process. ie. Do the sort, then search for words
like
Bordeaux and move it under France. I'm assuming you'd have a list of the
words that should be 'custom sorted.'

Mike

"sinkhole" wrote:

Is it possible to A-Z sort a list, and instruct certain cells to be
sorted by
a different word than is entered into that cell? For example, sort the
cell
containing "Bordeaux" as if it were the word"France" so that Bordeaux
will
always be grouped with the cells containing "France."

And/or, in a scenerio with two columns and many rows is it possible to
A-Z
sort by the first column, except where the word "see" appears in a cell
in
the second column Excel uses the word that follows "see" as the term by
which
that row is sorted. For example, the word in the first cell is
"Bordeaux"
and in the second cell is "see France," rather than sorting this with
the
B's, it is grouped with all rows that contain "France" in the first
column.

Thanks for any help!

HM