| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting
You are welcome, and thanks for the feedback.
-- John C "amezera" wrote: <happy dance <happy dance!!!! Thank you, you are a genius! It worked perfectly! I really appreciate your patience with me! You have made this excel dork's day. "John C" wrote: Small correction: C1: ="" -- John C "amezera" wrote: Ok, we're almost there. This time I did sort the entire area, sorted by B then A and it kept all the data together as it should, however Pat and Amy did not stay with Cindy. The column was sorted as if it was a normal sort, so everyone was in alphabetical order, and Pat and Amy were indented. "John C" wrote: After inserting the helper column, did you select the entire area to be sorted? Or did you select just column's A & B. You need to select the entire area, and then sort on column B first, then column A second. Hope this helps. -- John C "amezera" wrote: I tried Sheeloo's formula and it sort of worked, but the data was no longer accurate. When I sorted in the newly created column B, the data didn't sort, but the formulas moved around; some of the names were lost and other names were duplicated; and the data that follwed in columns C,D,E, etc were sorted to the wrong people. Perhaps this is a lost cause? "amezera" wrote: I have a list I need to sort. Column A has rows with indented text that needs to stay with above non-indented rows. How do I sort the whole column to keep indented text with non-indented text row above? In the below example, my end result should be Cindy with her group of Pat & Amy should come before Jack, but Pat and Amy remain indented. Is there a way to do this by keeping Amy & Pat indented in the same column A? Example: A 1 Jack 2 Cindy 3 Pat 4 Amy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting bug? | Excel Discussion (Misc queries) | |||
| Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
| Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
| Sorting | Excel Discussion (Misc queries) | |||
| sorting | New Users to Excel | |||
![John C[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
