View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default sorting grouped rows

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
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.