Auto Filter

[Oldjay]

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

 

[R.VENKATARAMAN]

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

 

[Norman Jones]

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,

 

[Guest]

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.