Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group cells during sort
Hello,
I have a sheet that has column A marked with a priority level. A, B, C and so on down the sheet. Across from that I have colum B with the project it applies too. In column C I have the details of each project listed down about 4 cells each. Now heres the question. Is there a way to group the block of rows together so if I sort by priority A, B, C... the blocks stay linked? If I sort now, it rearranges all of rows independantly. Thanks in advance for any help!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group cells during sort
hi
excel has no built in sort function for this that i am aware of. usually custom sorts are done with a helper column added to the side of the data. how many priority levels do you have? if less than 7 for 2003(16 for 2007 I think), you might be able to use a helper formula in the the helper column. if(A1="A",1,if(A1="B",2,if(A1="C",3,if(A1="D",4,0) ))) this would place a one in the helper column on the same row as all the A's, a 2 on the row with the B's and so on. you can then sort by the helper column as primary sort and some other as secondary sort. this would "group" all the A's,B's and C's. Regards FSt1 "John Boyee" wrote: Hello, I have a sheet that has column A marked with a priority level. A, B, C and so on down the sheet. Across from that I have colum B with the project it applies too. In column C I have the details of each project listed down about 4 cells each. Now heres the question. Is there a way to group the block of rows together so if I sort by priority A, B, C... the blocks stay linked? If I sort now, it rearranges all of rows independantly. Thanks in advance for any help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you sort within worksheet with grouped cells & keep cell group | Excel Worksheet Functions | |||
How do I sort a group of calculated cells in Excel? | Excel Worksheet Functions | |||
Trying to group cells so that I can sort the upper most cell with. | New Users to Excel | |||
How do i sort a group of cells from highest to lowest | Excel Discussion (Misc queries) | |||
How can I group a bunch of cells together, so I can sort by colum. | Excel Worksheet Functions |