Find all the names with same birthday

JohnTopley sir, Thnaks for the help.
But the formula or the way uou have done , i did not understand. Also the attachment is you have
given is not showing the names. Can u kindly correct it & resend, so that I can use this

It shows names in column D ???

no sir, when i down load the excel file it is showing #NAME?

This is due to the Excel version you have (2003)

Try these:

Named ranges


=Sheet1!$A$2:INDEX(Sheet1!$A2:$A1000,COUNTIF(Sheet1!$A2:$A1000,"?*"))


=Sheet1!$B$2:INDEX(Sheet1!$B2:$B1000,COUNTA(Sheet1!$B2:$B1000))


In D2

=IFERROR(INDEX($A$2:$A$1000,SMALL(IF(TEXT(Birth_Date,"ddmm")=TEXT($C$1,"ddmm"),ROW(Name)-ROW($A$2)+1,""),ROWS($1:1))),"")

thanks...working.
tomorrow I will use this in actual worksheet
Another request sir .
Kindly remove the column names & use the actual column like (A2: A100) and resent the excel format.
This is just for my under standing. It is a small request sir

Simply replace the names with $A$2:$A$1000 or $B$2:$B$1000 or whatever maximum you want.