Re: automatic sort

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi!

Here's one way but it will only sort based on the first character of the
text entry.

Assume the text entries are in the range A1:A20. To extract those entries
sorted in ascending order, enter this formula as an array with the key combo
of CTRL,SHIFT,ENTER:

=INDEX(A$1:A$20,MATCH(SMALL(CODE(UPPER(LEFT(A$1:A$20,1))),ROW(1:1)),CODE(UPPER(LEFT(A$1:A$20,1))),0))

Copy down as needed.

To sort in descending order, in the formula change SMALL to LARGE.

Biff

"malik641" <malik641.1rau2r_1119899192.7447@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:malik641.1rau2r_1119899192.7447@xxxxxxxxxxxxxxxxxxxxxxxx
>
> Anybody???
>
>
> --
> malik641
> ------------------------------------------------------------------------
> malik641's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=24190
> View this thread: http://www.excelforum.com/showthread.php?threadid=381859
>


.

Relevant Pages

  • Re: Reading a directory with DIR()
    ... the entries are returned in no particular order. ... should sort the records after being received. ... "Returned in ascending order" is only true for one particular order. ... What happens depends on the file system -- NTFS will differ from ...
    (comp.lang.basic.visual.misc)
  • Re: cell sortrows difficulty
    ... I have a cell array A that has the following format: ... I would like to sort both entries in ascending order based on the second column in both cases. ...
    (comp.soft-sys.matlab)
  • cell sortrows difficulty
    ... I would like to sort both entries in ascending order based on the second column in both cases. ...
    (comp.soft-sys.matlab)
  • Re: a two-level sort question
    ... > whereby the entries are first sorted/grouped by ... > and each block is sorted in an ascending order by date. ... > man sort gives the following example to sort ... > but I want to keep sorted blocks after the undersore as priority ...
    (comp.unix.questions)
  • Re: Fantasy Books not set in pseudo-Europe
    ... looking for this sort of thing and haven't read those, ... you have to go to the entries on the 1001 Nights and on "Persia" ... <Wheel of the Infinite> ... Fantasy rooted in no particular Earth historical culture is not, ...
    (rec.arts.sf.written)