select names from a list with criteria

[bruce71101]

I have a worksheet with a column of names and a column birthdays.
The birthdays is in text "yyyy.mm.dd"

I would like to figure out who should I held birthday party for in each month
so I would like to generate a column displaying the month they were born, it needs to read the text and make it into number. for example "2011.02.21" into "2"

Then I would like a function that look through the column of month and generate a large string of text with the names of people who was born in a particular month seperated by a comma, ex: "John Doe, Jane Doe, ......."

Is there a limit for the length of the string? There are around 100 people in the list, I doubt the stirng would go over 20 names.

Can anyone help me with that

[Marcol]

Maybe this UDF

Please Login or Register  to view this content.

Enter in excel as

Please Login or Register  to view this content.

Don't think there is a problem with string length except maybe if you copy the whole result as a sheet then in 2003 the string will truncate to 256 chars, if the cells are copied individually the all should be okay.
This is from memory I don't have a 2003 m/c handy at the moment to check.

The demo workbook has 250+ birthdays