Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort range changes during sort | Excel Discussion (Misc queries) | |||
Can I remove blanks from a range without using sort? | Excel Discussion (Misc queries) | |||
How do I get Excell to sort dates that range from 1800 to 1900's | New Users to Excel | |||
Sort a Range | Excel Discussion (Misc queries) | |||
How do I reference and sort a range of numbers in Excel 97? | Excel Worksheet Functions |