Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
highlight group of rows | Excel Worksheet Functions | |||
Selecting a group of contiguous rows | Excel Discussion (Misc queries) | |||
excel indenting a group of rows | Excel Discussion (Misc queries) | |||
TRANSPOSE 'group' of columns to rows | Excel Discussion (Misc queries) | |||
I can no longer Group rows | Excel Discussion (Misc queries) |