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