Re: sort

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: 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: sort
    ... as David susgested the first sort is to the right columns D-E-F then sort on ... I get a excel file. ... is there possible to generate a sequence? ... More information on sorting: ...
    (microsoft.public.excel.misc)
  • 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)
  • Error Message: File Not Saved
    ... buffer of some sort is filling up. ... >I have an excel file that contains vba code and is about ... so disk space and network ...
    (microsoft.public.excel.crashesgpfs)