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