[NFBCS] Excel, sorting by 2 columns

[Doug Lee]

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}