Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alpha sort, but some cells sorted by phantom term?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort alpha neumeric fields that have an alpha suffix? | Excel Worksheet Functions | |||
Updating workbook with an alpha sort sheet and a numeric sort shee | Excel Discussion (Misc queries) | |||
Compare & align 2 cols of Employee Names in sorted alpha order withVBA | Excel Discussion (Misc queries) | |||
Sort data and have it skip everyother row when it is sorted | Excel Discussion (Misc queries) | |||
How do I sort and put a space between each sorted choice | Excel Worksheet Functions |