Sorting data on a worksheet

cbrd

Board Regular
Joined
Dec 30, 2005
Messages
72
I have a worksheet which imports its values from another worksheet. I have columns labeled [Customer ID] and [Date]. When I choose (in toolbar) DATA then SORT and do it by (column A)CUST ID then by (column B)DATE, it comes out wrong. It sorts all the customer ID's out right, but the dates come out like this:

6/17/2007
6/24/2007
7/8/2007
7/15/2007
7/22/2007
6/31/2007

No matter what I try, its putting June 31st last.
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

schielrn

Well-known Member
Joined
Apr 4, 2007
Messages
6,941
One thing I notice is that 6/31/2007 is not an accurate date. There are only 30 days in June. Maybe the sort does not know what to do with that date?
 

cbrd

Board Regular
Joined
Dec 30, 2005
Messages
72
Thanks, that worked well. I had a mistake with the date.
 

Forum statistics

Threads
1,181,730
Messages
5,931,703
Members
436,799
Latest member
BasOo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top