sorting grouped rows

[david tlv]

i have a very important list, some of the rows must be grouped (so you see
the plus sign on the left). when sorting the whole list - i'm loosing the
groups.
i would expect the excel to treat grouped rows like it was one row.
instead it's spreading them according to the sub content.

by the way - the plus remains in front of the original row number of the
work sheet, even if the row content has changed place according to the
sorting.
so for instance if i grouped some rows to a single row, and it happend to be
the row number 27, so after the sorting the plus remains infront of row 27
but the content has changed according to the sorting.

 

[Jim Cone]

You will probably have to use another column and add an unique identifier
for each group.
So your first group might have "AAAA" in each row and the next group
would have "BBBB" in each row (in the new column) and so on.
--
Jim Cone
Portland, Oregon USA




"david tlv"
<david (e-mail address removed)>
wrote in message
i have a very important list, some of the rows must be grouped (so you see
the plus sign on the left). when sorting the whole list - i'm loosing the
groups.
i would expect the excel to treat grouped rows like it was one row.
instead it's spreading them according to the sub content.

by the way - the plus remains in front of the original row number of the
work sheet, even if the row content has changed place according to the
sorting.
so for instance if i grouped some rows to a single row, and it happend to be
the row number 27, so after the sorting the plus remains infront of row 27
but the content has changed according to the sorting.

 

[david tlv]

jim thanks for the advice.
the amasing (frustrating) thing is that from some unknown reason, one of the
sheets is acting different and it's actualy working well !!!
i mean, the sorting doesn't changes the grouped rows and the grouped rows
swich place together like it was one row.
i don't know what i did but i must have done something else in all other
sheets because only one of them is working properly.
it's like - shit man, only one sheet.
i'm kidding but i'm frustrated because i want to group & sort in other
sheets, it's replacing the costomer relations info. system. it's a list of
companies, and i every company must have several rows, (you know - manager,
assistant, secretary, each is different row) and then i can't group and sort
the whole list.
and like i said in one of the sheets it's working.
but i have different lists and want to know how to make it work in all of
them!

 

[david tlv]

thanks jim
i know there is an option to sort grouped rows, it works in one of the
sheets i created!
i have no idea why or what did i do differently in the other sheets
i have probably done something in the only sheet that it's working there
i think it's something to do with table definitions.