ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I sort data? (https://www.excelbanter.com/excel-worksheet-functions/110687-how-do-i-sort-data.html)

madobbs

How do I sort data?
 
I have a range of data and needed to sort it by more than three types. When
I go to "data" then "sort" it only gives me three different sort types. Is
there any other way that I can sort 4 or more types.

Dave F

How do I sort data?
 
Not unless you use Excel 2007, which is still in beta mode.

Dave
--
Brevity is the soul of wit.


"madobbs" wrote:

I have a range of data and needed to sort it by more than three types. When
I go to "data" then "sort" it only gives me three different sort types. Is
there any other way that I can sort 4 or more types.


Jim Cone

How do I sort data?
 
Sort the least significant items first and then the next group of 3.
So... sort 4, 5, and 6 then sort 1, 2, and 3.
(select all of the data when sorting... items 1 thru 6)
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html


"madobbs"

wrote in message
I have a range of data and needed to sort it by more than three types. When
I go to "data" then "sort" it only gives me three different sort types. Is
there any other way that I can sort 4 or more types.


All times are GMT +1. The time now is 07:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com