Re: sort

If I read your second post correctly.

With all sorting you must select all columns then sort on three columns and
as David susgested the first sort is to the right columns D-E-F then sort on
columns A-B-C.

Without selecting all columns sorting on A-B-C will sort only columns A-B-C
leaving the rest as is, hence jumbelling the rows.

HTH

--
Thank you

Bob C
It cost''''''''s little to carry knowledge with you.


"othellomy@xxxxxxxxx" wrote:

Thanks. It breaks the row information. No? For example if I sort them
by column A, B and C. I get a excel file. Then if I sort them by D, E
and F then the rows are not correct anymore. Therefore, I get wrong
information in a row.
Since we are at it, is there possible to generate a sequence? For
example I have a excel file and I want to insert a column to the left
and fill that column with a sequence, so that each row is numbered
form 1 though the highest row number? Thanks again.


On Feb 5, 10:52 am, "David McRitchie" <dmcritchie_xl...@xxxxxxxxxxx>
wrote:
sort the minor columns first
D-E-F
then the major columns
A-B-C

More information on sorting:
http://www.mvps.org/dmcritchie/excel/sorting.htm

If you have Excel 2003 then you will have to avoid
the Ctrl+A problem introduced with that version
http://www.mvps.org/dmcritchie/excel/shortx2k.htm#foobar
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm



<othell...@xxxxxxxxx> wrote in messagenews:1170650847.913056.25610@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
How can I sort the columns in my excel file when it exceeds more than
3? Suppose I have a excel file that has 100 columns and several
thousand rows. How can I sort the file based on 10 columns? Thanks.- Hide quoted text -

- Show quoted text -



.

Relevant Pages

  • Re: What about an EXPLICIT naming scheme for built-ins?
    ... But having sortedto return a iterator ... sortedreturns a brand new sorted sequence. ... -- sorting long sequences to use only a few of the first elements. ... if you need to sort a long list to get the top 10 elements. ...
    (comp.lang.python)
  • Re: Sorting "X1 X10 X2" in correct order as "X1 X2 X10"
    ... in the number of letters and numbers in my excel file. ... Here is just one row in the .dbf-file, and I want to sort it by the ... here are the formulas assuming your raw data begins in A1 ...
    (microsoft.public.excel)
  • Re: xlrd and cPickle.dump
    ... the rows in the excel file, my computer gets very slow and choppy, ... which makes experimenting slow and frustrating. ... My code does this, except sort returns None, which is strange. ... want an alphabetical sort of the first option, ...
    (comp.lang.python)
  • Re: Deleting excel rows based on multiple criteria
    ... Sort in original order. ... I am looking for hel to delete data from one of the huge excel file I ... one of the excel file search for that UserName in the file and delete ...
    (microsoft.public.excel.programming)
  • Re: sort
    ... I get a excel file. ... Then if I sort them by D, ... is there possible to generate a sequence? ... David McRitchie, Microsoft MVP - Excel ...
    (microsoft.public.excel.misc)