[NFBCS] Excel, sorting by 2 columns

[Steve Shelton]

I have used this technique  many times over the years. I've never had a case
where the subsequent sort changes the order of the prior sort column.
Typically, I used this when I was trying to do something quickly for myself
and didn't want to take time to mess with the EXCEL custom sort.  

Steve

  

-----Original Message-----
From: NFBCS <nfbcs-bounces at nfbnet.org> On Behalf Of Doug Lee via NFBCS
Sent: Friday, July 1, 2022 12:28 PM
To: NFB in Computer Science Mailing List <nfbcs at nfbnet.org>
Cc: Doug Lee <dgl at dlee.org>
Subject: Re: [NFBCS] Excel, sorting by 2 columns

I admit that solution fascinates me! I never paid attention to whether the
Excel sorting algorithm was both stable and predictable in that equal items
in one sort will not be rearranged at all. I suppose this even means that
complicated sorts involving reversals of some but not all columns could be
accomplished one step at a time via careful decisions of how to sort each
time.

On Fri, Jul 01, 2022 at 12:42:39PM -0400, NFBCS mailing list wrote:
By George, it worked!  Thanks Steve.  Way simpler than the custom sort.
Tracy


-----Original Message-----
From: NFBCS [mailto:nfbcs-bounces at nfbnet.org] On Behalf Of Steve Shelton via
NFBCS
Sent: Friday, July 01, 2022 12:15 PM
To: 'NFB in Computer Science Mailing List'
Cc: Steve Shelton
Subject: Re: [NFBCS] Excel, sorting by 2 columns

A quick and dirty way to accomplish this without using the custom sort is to
do two sorts. If you want it in Date/Time order, first sort by time column
then by date on the second sort.

Steve
Steve

-----Original Message-----
From: NFBCS <nfbcs-bounces at nfbnet.org> On Behalf Of Tracy Carcione via NFBCS
Sent: Friday, July 1, 2022 9:29 AM
To: 'NFB in Computer Science Mailing List' <nfbcs at nfbnet.org>
Cc: Tracy Carcione <carcione at access.net>
Subject: [NFBCS] Excel, sorting by 2 columns

I have a spreadsheet I want to sort by date and then time, so that I get the
events in sequence by date/time.  

I found instructions for doing it, but, when I get into the custom sort
dialog, Jaws doesn't read the column names, so I can't select the ones I
want. 

Does anyone know how to do this?

I am using Excel 2016 and the current Jaws.

Thanks.

Tracy

-- 
Doug Lee                 dgl at dlee.org                http://www.dlee.org
"The most exhausting thing in life is being insincere."
        - Anne Morrow Lindbergh {American Author}

_______________________________________________
NFBCS mailing list
NFBCS at nfbnet.org
http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
To unsubscribe, change your list options or get your account info for NFBCS:
http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/stevesheltonokc%40gmail.c
om