A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

sorting grouped rows



 
 
Thread Tools Display Modes
  #1  
Old February 15th 09, 09:02 PM posted to microsoft.public.excel.misc
david tlv
external usenet poster
 
Posts: 1
Default sorting grouped rows

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.
Ads
  #3  
Old February 21st 09, 07:55 PM posted to microsoft.public.excel.misc
david tlv[_2_]
external usenet poster
 
Posts: 1
Default sorting grouped rows

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.

"Jim Cone" wrote:

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Grouped columns & rows WBKLAK Excel Worksheet Functions 2 September 27th 06 07:06 PM
How to search for grouped rows? Minerva Excel Worksheet Functions 1 June 27th 06 06:18 AM
How to sort by grouped rows Mike Excel Discussion (Misc queries) 2 April 5th 05 10:51 PM
Numbering of Grouped Rows Phil Excel Discussion (Misc queries) 2 February 1st 05 12:38 AM
Grouped Columns/Rows bayhe Excel Worksheet Functions 2 December 15th 04 01:05 PM


All times are GMT +1. The time now is 05:26 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.