Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
UB UB is offline
external usenet poster
 
Posts: 120
Default Sorting data by columns

Hi
I am posting this question again.

I need to sort the data in my excell sheet using 4 columns
Ex: The data should sort by column b, then column d, then column e and then
column m
The sort function avaibale in excell aloows to sort using 3 columns only.

Please advise how I can sort my data using 4 columns.

Thanks in advance
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default Sorting data by columns

http://support.microsoft.com/kb/268007

Regards,
Ryan---

--
RyGuy


"ub" wrote:

Hi
I am posting this question again.

I need to sort the data in my excell sheet using 4 columns
Ex: The data should sort by column b, then column d, then column e and then
column m
The sort function avaibale in excell aloows to sort using 3 columns only.

Please advise how I can sort my data using 4 columns.

Thanks in advance

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default Sorting data by columns

Select the lot. First Sort: by D, and E, and M. Then Sort again, by B.
--
David Biddulph

"ub" wrote in message
...
Hi
I am posting this question again.

I need to sort the data in my excell sheet using 4 columns
Ex: The data should sort by column b, then column d, then column e and
then
column m
The sort function avaibale in excell aloows to sort using 3 columns only.

Please advise how I can sort my data using 4 columns.

Thanks in advance



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
UB UB is offline
external usenet poster
 
Posts: 120
Default Sorting data by columns

Thanks a lot ,It works
"David Biddulph" wrote:

Select the lot. First Sort: by D, and E, and M. Then Sort again, by B.
--
David Biddulph

"ub" wrote in message
...
Hi
I am posting this question again.

I need to sort the data in my excell sheet using 4 columns
Ex: The data should sort by column b, then column d, then column e and
then
column m
The sort function avaibale in excell aloows to sort using 3 columns only.

Please advise how I can sort my data using 4 columns.

Thanks in advance




  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
UB UB is offline
external usenet poster
 
Posts: 120
Default Sorting data by columns

Thanks a lot, it works

"ryguy7272" wrote:

http://support.microsoft.com/kb/268007

Regards,
Ryan---

--
RyGuy


"ub" wrote:

Hi
I am posting this question again.

I need to sort the data in my excell sheet using 4 columns
Ex: The data should sort by column b, then column d, then column e and then
column m
The sort function avaibale in excell aloows to sort using 3 columns only.

Please advise how I can sort my data using 4 columns.

Thanks in advance

Reply
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
Sorting Data into columns without replacing the columns with data Sandaime New Users to Excel 2 October 18th 07 01:35 PM
Sorting more than 3 columns of Numeric data. JMax Excel Discussion (Misc queries) 3 December 16th 05 06:54 PM
sorting data across multiple columns Spiderman Excel Discussion (Misc queries) 2 October 6th 05 11:55 PM
sorting data in columns Spiderman Excel Discussion (Misc queries) 2 October 6th 05 09:45 PM
Sorting two columns of data Max Excel Worksheet Functions 6 June 13th 05 01:30 AM


All times are GMT +1. The time now is 02:23 PM.

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

About Us

"It's about Microsoft Excel"