LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
-random-
 
Posts: n/a
Default Sorting by Group of Cells

I doubt this can be done, but it sure would be handy.

Column is grouped by conceptual blocks, (note, there is not second column of
unique data) eg:

Cheese
Cheddar
Blue
Swiss
Bread
Italian
Bran
French

I want to sort by alpha so that I get (evenutally):

Bread
Bran
French ...
Cheese
Blue
Cheddar ...

Aside from setting up the table in two columns (Bread/Cheese; Types) and
making sure Bread/Cheese is in each column-cell that correspondes to the
types and THEN sorting - is there another way to do this? Grouping?
Protection?

thx
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display contents of a specific cell even if a group of cells is mo Larry Heine Excel Worksheet Functions 5 December 4th 08 10:33 PM
Sorting Cells by Colors swiftcode Excel Discussion (Misc queries) 2 September 26th 05 10:53 AM
Sorting Area with Merged Cells prizm1 New Users to Excel 3 September 10th 05 11:49 PM
excel group sorting meehaha Excel Discussion (Misc queries) 1 July 5th 05 06:07 PM
Trying to group cells so that I can sort the upper most cell with. magnetoworld New Users to Excel 8 March 14th 05 07:17 PM


All times are GMT +1. The time now is 01:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"