Auto Filter
 

I have a membership list with col F having the birthdays with a text format
of 05/19 (I could change the format if necessary). I need to make a list of
birthdays occuring in a certain month

Any help would be appreicated

oldjay

Auto Filter
 

try
assming the dates e.g. 5/19 is in text format
introduce a header row if it is not avilable

autofilter
custom
equlas to 5/*

* is wild card




"Oldjay" wrote in message
...
I have a membership list with col F having the birthdays with a text
format
of 05/19 (I could change the format if necessary). I need to make a list
of
birthdays occuring in a certain month

Any help would be appreicated

oldjay

Auto Filter
 

Hi Oldjay,

Set the custom filter condition for column F to:

Equals MM*

where MM is the month nimber, i.e. 01* for January birthdays,

---
Regards,
Norman



"Oldjay" wrote in message
...
I have a membership list with col F having the birthdays with a text format
of 05/19 (I could change the format if necessary). I need to make a list of
birthdays occuring in a certain month

Any help would be appreicated

oldjay

Auto Filter
 

You are correct that auto filter is a reasonable approach. We only need to
isolate the month. In an un-used column insert =LEFT(F1,2) and copy down.
This will be the month. Autofilter on this column to get your monthly list.
--
Gary's Student


"Oldjay" wrote:

I have a membership list with col F having the birthdays with a text format
of 05/19 (I could change the format if necessary). I need to make a list of
birthdays occuring in a certain month

Any help would be appreicated

oldjay