sorting

  • Thread starter Thread starter Roy Gudgeon
  • Start date Start date
R

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 ?
 
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.
 
With data in A1, in B1 enter:
=MONTH(A1) and copy down

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