sorting
 

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 ?
--
thanks
Roy

sorting
 

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.
--
John C


"Roy Gudgeon" wrote:

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 ?
--
thanks
Roy

sorting
 

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

sort your data first by column B and then by column A
--
Gary''s Student - gsnu200796

sorting
 

Top man Gary

sorted me out no problem
--
thanks
Roy


"Gary''s Student" wrote:

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

sort your data first by column B and then by column A
--
Gary''s Student - gsnu200796