Sorting Multiple Variable Types in Excel 2004 for Mac OS X Panther

[David Wilcox]

Hey, everyone. Thanks for any help you can provide.

Here's the deal.

I've got a large spreadhseet (3000+ rows) with calendar information in
it. The pertinent columns are...

Column A = Event Name
Column B = Event Date
Column D = Event Start Time

I want to sort it in time-based-order, so I sort it...

Column B (date), then
Column D (time), then
Column A (event name)

For some reason, Columns B and D sort fine, but then Column A only
sorts part way. Some events which are identical do not end up on
successive lines.

I have already tried to reformat each column according to "Text,"
"Date," "Time," etc. to force the data type. That didn't change
anything.

Any ideas on what might be happening? How I can make sure that
everything sorts correctly?

I have an applescript that runs based on a pre-formatted spreadsheet,
but it's not working because I can't get the data sorted correctly to
begin with.

Thanks!

David Wilcox

 

[JE McGimpsey]

The pertinent columns are...

Column A = Event Name
Column B = Event Date
Column D = Event Start Time

I want to sort it in time-based-order, so I sort it...

Column B (date), then
Column D (time), then
Column A (event name)

For some reason, Columns B and D sort fine, but then Column A only
sorts part way. Some events which are identical do not end up on
successive lines.

I have already tried to reformat each column according to "Text,"
"Date," "Time," etc. to force the data type. That didn't change
anything.

Any ideas on what might be happening? How I can make sure that
everything sorts correctly?

if you want identical events to sort together, then the events column
has to be the first column in the Sort dialog.

To sort events together, then by date, then by time, sort column A, then
column B, then column D.