Group cells during sort

[John Boyee]

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!!

 

[FSt1]

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