Sort month/date/year data using month and date only
 

Hi,

I am attempting to sort a list of companies that are formatted in our
database system by month/date/year (mm/dd/yyyy). I want them to sort by
month and date only, however Excel 2000 recognizes the year as a criteria.

How do I get the program to ignore the year information for these 4,000+
entries?

Thanks so much.
SMW820

Sort month/date/year data using month and date only
 

An indirect way:
Insert two extra columns - one for month using MONTH function and another
for day using DAY function.
Then sort by month and day.

--
Best regards,
---
Yongjun CHEN
==================================
- - - - www.XLDataSoft.com - - - -
Free Excel/VBA Tool & Training Material
==================================
"SMW820" wrote in message
...
Hi,

I am attempting to sort a list of companies that are formatted in our
database system by month/date/year (mm/dd/yyyy). I want them to sort by
month and date only, however Excel 2000 recognizes the year as a criteria.

How do I get the program to ignore the year information for these 4,000+
entries?

Thanks so much.
SMW820

Sort month/date/year data using month and date only
 

Hi,

you could use an auxiliar column with =month(a1)&day(a1) copy it down and
sort by this column

HTH
Regards from Brazil
Marcelo

"SMW820" escreveu:

Hi,

I am attempting to sort a list of companies that are formatted in our
database system by month/date/year (mm/dd/yyyy). I want them to sort by
month and date only, however Excel 2000 recognizes the year as a criteria.

How do I get the program to ignore the year information for these 4,000+
entries?

Thanks so much.
SMW820

Sort month/date/year data using month and date only
 

Hi Daniel:

Thank you for your solution. At first I did not understand. After reading
the second response from Marcelo, I got it! And it worked!

Thanks again.
SMW820

"Daniel CHEN" wrote:

An indirect way:
Insert two extra columns - one for month using MONTH function and another
for day using DAY function.
Then sort by month and day.

--
Best regards,
---
Yongjun CHEN
==================================
- - - - www.XLDataSoft.com - - - -
Free Excel/VBA Tool & Training Material
==================================
"SMW820" wrote in message
...
Hi,

I am attempting to sort a list of companies that are formatted in our
database system by month/date/year (mm/dd/yyyy). I want them to sort by
month and date only, however Excel 2000 recognizes the year as a criteria.

How do I get the program to ignore the year information for these 4,000+
entries?

Thanks so much.
SMW820

Sort month/date/year data using month and date only
 

Hi Marcelo:

Thank you for your response. I had received another similar solution prior
to yours, and did not understand. I gained clarity after reading your
answer. And it worked!

Thanks so much.
SMW820


"Marcelo" wrote:

Hi,

you could use an auxiliar column with =month(a1)&day(a1) copy it down and
sort by this column

HTH
Regards from Brazil
Marcelo

"SMW820" escreveu:

Hi,

I am attempting to sort a list of companies that are formatted in our
database system by month/date/year (mm/dd/yyyy). I want them to sort by
month and date only, however Excel 2000 recognizes the year as a criteria.

How do I get the program to ignore the year information for these 4,000+
entries?

Thanks so much.
SMW820

Sort month/date/year data using month and date only
 

Marcelo Wrote:
Hi,

you could use an auxiliar column with =month(a1)&day(a1) copy it down
and
sort by this column

HTH
Regards from Brazil
Marcelo



I think you'd have a problem with this approach. 11th January and 1st
november would both become 111.

For a one column approach try

=DATE(0,MONTH(A1),DAY(A1))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=554245

Sort month/date/year data using month and date only
 

Hi "daddylonglegs",

Yes, I can see where this might become an issue and luckily I did not have
any of these dates in the system. However, I will also keep this version of
the recommended solutions on hand for future reference.

Thanks very much for your help.
SMW820

"daddylonglegs" wrote:


Marcelo Wrote:
Hi,

you could use an auxiliar column with =month(a1)&day(a1) copy it down
and
sort by this column

HTH
Regards from Brazil
Marcelo



I think you'd have a problem with this approach. 11th January and 1st
november would both become 111.

For a one column approach try

=DATE(0,MONTH(A1),DAY(A1))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=554245