Hey Guys n' Gals
Many thanks for your help. Will probably try them all just for the
experience.
Been using a 'Filter' which, as you know, groups the their name and all
birthdays in that month.
Many thanks




"Alan" wrote in message
...


Hi,

Can anyone tell how to resolve this wee problem or, in nice words, where
to go to find help.



I have a group of 'special needs 'using a spreadsheet with a list of
their name and birthday.

It lists their birthday in one cell as: 1/6/46 and the month: June in
a another.



Is it possible to list the total number of students that have birthdays
in say: March or any month throughout the year by clicking or typing in
the month from a range (Jan to Dec)?



I want to type or click a month and it list everyone's birthday for the
Months.

Do I have to create a Macro or can it be done with a formula and, HOW
please?



Many thanks for your help.