#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default Row groups

Hi!
Let's assume rows 1-10
I want to create 2 consecutive groups (using data/group and outline/group).
One group will be rows 1-4 and the second group will be rows 5-10. After
having created the first group, when I try to create the second one it
automatically merges with the first one and results to a single group for
rows 1-10. Any idea?
thanx
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Row groups

Just an obs. Think you need to leave a row in-between.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Petros" wrote:
Hi!
Let's assume rows 1-10
I want to create 2 consecutive groups (using data/group and outline/group).
One group will be rows 1-4 and the second group will be rows 5-10. After
having created the first group, when I try to create the second one it
automatically merges with the first one and results to a single group for
rows 1-10. Any idea?
thanx

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default Row groups

Thanx but I am looking for a solution that does not need an additional row

"Max" wrote:

Just an obs. Think you need to leave a row in-between.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Petros" wrote:
Hi!
Let's assume rows 1-10
I want to create 2 consecutive groups (using data/group and outline/group).
One group will be rows 1-4 and the second group will be rows 5-10. After
having created the first group, when I try to create the second one it
automatically merges with the first one and results to a single group for
rows 1-10. Any idea?
thanx

  #4   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Row groups

Thanx but I am looking for a solution that does not need an additional row
Understood, albeit I believe that is the inherent constraint behind that
functionality. Do hang around awhile though for possible responses from
others.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
counting age groups chedd via OfficeKB.com Excel Worksheet Functions 5 September 27th 07 07:52 AM
How to gt Top N records/Top N Groups Pat Dools Excel Discussion (Misc queries) 0 March 8th 07 08:16 PM
Groups of numbers evanr Excel Worksheet Functions 1 February 2nd 06 11:18 PM
SUM OF GROUPS ADK Excel Worksheet Functions 5 October 28th 05 08:04 PM
how do i view all groups under excel in google groups JulieD Excel Discussion (Misc queries) 2 December 16th 04 04:33 PM


All times are GMT +1. The time now is 08:40 PM.

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

About Us

"It's about Microsoft Excel"