Can I sort by Range Name?
 

I have a complicated spreadsheet that contains what I'll call "sub
heads" and I need to sort by these. For example, I have this sort of
data:

Owner Name Pets Pet Age
-------------------------------------
Randy's Pets
Dog 3
Cat 5

Tim's Pets
Cat 4
Bird 9

Sue's Pets
Goldfish 1


How could I sort by the Owner Name, and retain the information
organization under each name? Currently, all I get it is this result:

Owner Name Pets Pet Age
-------------------------------------
Randy's Pets
Sue's Pets
Tim's Pets
Bird 9
Cat 4
Cat 5
Dog 3
Goldfish 1



What I need is this result:

Owner Name Pets Pet Age
-------------------------------------
Randy's Pets
Cat 5
Dog 3

Sue's Pets
Goldfish 1


Tim's Pets
Bird 9
Cat 4


--
DeepSouthRick
------------------------------------------------------------------------
DeepSouthRick's Profile: http://www.msusenet.com/member.php?userid=1811
View this thread: http://www.msusenet.com/t-1870503762

Use a separate column for the name, say column D. Replicate the name in all
rows that pertain to that person. i.e. D3:D5 would all say "Randy". Now sort
all 4 columns, using column D as the key.


On Wed, 1 Jun 2005 09:32:08 -0500, DeepSouthRick
wrote:


I have a complicated spreadsheet that contains what I'll call "sub
heads" and I need to sort by these. For example, I have this sort of
data:

Owner Name Pets Pet Age
-------------------------------------
Randy's Pets
Dog 3
Cat 5

Tim's Pets
Cat 4
Bird 9

Sue's Pets
Goldfish 1


How could I sort by the Owner Name, and retain the information
organization under each name? Currently, all I get it is this result:

Owner Name Pets Pet Age
-------------------------------------
Randy's Pets
Sue's Pets
Tim's Pets
Bird 9
Cat 4
Cat 5
Dog 3
Goldfish 1



What I need is this result:

Owner Name Pets Pet Age
-------------------------------------
Randy's Pets
Cat 5
Dog 3

Sue's Pets
Goldfish 1


Tim's Pets
Bird 9
Cat 4