Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / August 2007

Tip: Looking for answers? Try searching our database.

can you group together rows to remain intact while sorting?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
justusmomm - 26 Aug 2007 17:36 GMT
I have a list which needs to  consilidated with another and then sorted
chronologically.  I  neede to lock or group together certain set of  rows  
please i am way past my deadline......thanks
Bernard Liengme - 26 Aug 2007 18:06 GMT
Add a helper column
Put numbers in this column
Row that must stay together, give same number
Use this as the first sort key
best wishes
Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

>I have a list which needs to  consilidated with another and then sorted
> chronologically.  I  neede to lock or group together certain set of  rows
> please i am way past my deadline......thanks
Ragdyer - 26 Aug 2007 18:36 GMT
When you use "Subtotals" or "Group & Outline", you can sort the summary
(subtotal) rows, leaving the grouped rows intact, as individual units.

For example, to manually group some rows, enter A, B, C, ...etc down Column
A, say to A20.

In B1 enter
1/1/07

In C1 enter
=Rand()

Select *both* B1 and C1, and using the fill handle, drag down to Row 20.
While both columns are *still* selected, click,
<Data> <Sort>
Sort by Column C - <OK>

You now have Column A in order, with various dates in Column B.

Select rows 1, 2, and 3 by clicking in the row headers.
While these rows are selected,
hold down <Shift> and <Alt>
and hit the <Right Arrow>.

You have now manually grouped the first 3 rows, with A, B, and C.

Do exactly the same thing, grouping rows 8, 9, and 10, with H, I, and J,
and also rows 16, 17, and 18, with P,Q, and R.

You see the minus sign by rows 4, 11, and 19.
This means that *each* 3 row group will remain intact, and sort as a group,
depending on the value in rows 4, 11 and 19.

NOW ... select A1 to B20, and sort on Column B.

This puts everything in chronological order, *except* the individual groups,
which are dependant on the date in their respective summary rows.
Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> I have a list which needs to  consilidated with another and then sorted
> chronologically.  I  neede to lock or group together certain set of  rows
> please i am way past my deadline......thanks
Ragdyer - 26 Aug 2007 19:01 GMT
FWIW,

After the sort, you can hit:
<Ctrl> <8>
to toggle the Outline symbols to display or hide.

That "8" *must* be the 8 that's under the function keys.
The one from the num keypad *doesn't* work!
Signature

Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> When you use "Subtotals" or "Group & Outline", you can sort the summary
> (subtotal) rows, leaving the grouped rows intact, as individual units.
[quoted text clipped - 36 lines]
> > chronologically.  I  neede to lock or group together certain set of  rows
> > please i am way past my deadline......thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.