View Single Post
  #1   Report Post  
DeepSouthRick
 
Posts: n/a
Default 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