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

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

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

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

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

Sinkhole,

Without a list of French terms to accompany your long list there is no code
that you can write that will accomplish this sort. You must have a list of
terms that should be sorted under France otherwise the code will not know.
VBA does not intuitively know which words you want sorted under France. You
must tell it.

If you can provide a list then code can be written.

Mike

"sinkhole" wrote:

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