Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default Sort

I have the following table:
2 A 2 A
1 A 2 A
1 B 2 B
1 A 1 A
2 A 1 B
1 B 1 A
2 A 2 B
1 A 2 B
2 A 2 B
2 B 1 B
2 B 1 A
2 B 2 A
2 A 1 A
1 A 1 B
1 B 2 A
1 B 1 B

After I sort on column A, B and C I get:
1 A 1 A
1 A 1 B
1 A 2 A
1 A 2 B
1 B 1 A
1 B 1 B
1 B 2 B
1 B 2 A
2 A 1 B
2 A 1 A
2 A 2 A
2 A 2 B
2 A 2 B
2 B 1 B
2 B 1 A
2 B 2 A

I want to include column D into the sort. Right now the sort is wrong
on row 7 and after that few more rows. How to sort so that column D is
sorted and column A, B and C also remain sorted? Thanks.

 
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
Saving Sort Criteria (or Sort Lists) Jim J. Excel Worksheet Functions 1 July 25th 06 10:55 AM
How can I sort one column and have the entire row sort. (binding) Blue Excel Worksheet Functions 10 November 13th 05 07:09 PM
Excel sort by Fill Color by custom list sort Dash4Cash Excel Discussion (Misc queries) 2 July 29th 05 10:45 PM
Excel Sort function should not sort the cell formatting! Lisa D.N.1 Excel Worksheet Functions 1 December 28th 04 08:37 PM
how can I hide sort ascending and sort descending options in the . vida Excel Discussion (Misc queries) 0 December 11th 04 12:31 AM


All times are GMT +1. The time now is 05:25 AM.

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"