Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default group rows

help,
I am entering data for management of a project:

ROW1:
Column1 = Project ID
Column2 = Project location
Column3 = Project status
Column4 = Date of comments
Column5 = Comments

ROW2:
Column1 = BLANK
Column2 = BLANK
Column3 = BLANK
Column4 = (new) Date of (new) comments
Column5 = (New) Comments

and on and on, adding many more Projects and their multiple lines of dates
comments.

I want to be able to sort by the STATUS column. When I do this, all the
multiple rows that lie benaeth the 1st Row of the Project, do not remain
adjacent to their initial Project 1st Row. Only the rows like the ROW1
example above sort.

I have looked into GROUPING of rows but can't seem to get this to work for
how I need it.

I need to be able to clump those rows together and stay together for a sort
that will use the data of the clump's 1st row.

help! thanks in advance


 
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
highlight group of rows lilleke Excel Worksheet Functions 8 September 12th 07 01:40 PM
Selecting a group of contiguous rows jfg Excel Discussion (Misc queries) 1 August 7th 07 06:34 AM
excel indenting a group of rows [email protected] Excel Discussion (Misc queries) 3 June 27th 07 05:11 PM
TRANSPOSE 'group' of columns to rows tom Excel Discussion (Misc queries) 1 December 14th 06 06:19 AM
I can no longer Group rows ec8spe Excel Discussion (Misc queries) 5 August 12th 06 01:57 AM


All times are GMT +1. The time now is 04:20 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"