sorting

[Roy Gudgeon]

me again....

I have a spreadsheet that contains dates written in the following format:

dd/mm/yy

I want to be able to sort by month, then day within the month, currently
sort is by day and I therefore have a result that mixes the months.

any advice ?

 

[John C]

Ensure the cells are actually formatted dd/mm/yy, then sort by date,
ascending (or descending if you choose). Your months will be grouped
correctly.

Works for me, I have xl2003.

 

[Gary''s Student]

With data in A1, in B1 enter:
=MONTH(A1) and copy down

sort your data first by column B and then by column A

 

[Roy Gudgeon]

Top man Gary

sorted me out no problem