Re: Changing the position of rows

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 03/15/04 

Date: Mon, 15 Mar 2004 08:11:30 -0500

You a dummy column next to your data. Put in a formula that produces a
ranking that will produce the required results. Then sort the data using
this column as the key. 

-- 
Regards,
Tom Ogilvy
"maysam >" <<maysam.1358kk@excelforum-nospam.com> wrote in message
news:maysam.1358kk@excelforum-nospam.com...
> Thanks for response, but some thing:
> It dosn't necessarily mean sorting, for example in a column, I may have
> values in range of -1000 to 1000, and I may want to bring the 0 values
> to the top of the rows which is not kind of sorting, is it?
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

Relevant Pages

  • Re: Ranking numbers AND text
    ... >No, not really sorting, I don't want to have to sort them manually, but rank ... but if the formula above could be used to sort the ... The specific formula above gives the ranking of cell A1 ...
    (microsoft.public.excel.worksheet.functions)
  • Re: A Fast sorting algorithm for almost sorted data
    ... far my compressor has potential but is nowhere near ready. ... It does however make heavy use of sorting. ... which I am currently calling Run sort. ... entire selected run can be added to the sorted output array. ...
    (comp.compression)
  • Re: Solution for sorting an array alpha-numerically
    ... strings up into groups and sorting the groups seperately, ... > so that numeric and alphabetic data sort as seperate groups. ... To the same project as the web page, add the class AlphaNumCompare() ...
    (microsoft.public.dotnet.general)
  • Re: how fast can I sort on mainframe (using DFSORT)?
    ... Since I joined the team as the performance lead a couple years ago, ... Frank now defers these types of questions to me. ... I have been out of the sorting business for a while, ... Writing to sort work files should not be the problem, ...
    (bit.listserv.ibm-main)
  • Re: When random isnt random
    ... >> (and, if there is not one already, a Sorting Unit). ... TList has a Sort method. ... Try it with a TList and in the compare function ... There seems to be, sometimes, a requirement for a Shuffle that leaves ...
    (borland.public.delphi.language.objectpascal)