Try
=IFERROR(INDEX(Table1,SMALL(IF((MONTH(Table1[@[Date of Birth]])=MONTH(TODAY()))*(DAY((Table1[@[Date of Birth]]))=DAY(TODAY())),ROW(Table1[Date of Birth])-ROW($C$4)+1,""),ROWS($A$4:A4)),MATCH(G$3,Table1[#Headers],0)),"")
Try
=IFERROR(INDEX(Table1,SMALL(IF((MONTH(Table1[@[Date of Birth]])=MONTH(TODAY()))*(DAY((Table1[@[Date of Birth]]))=DAY(TODAY())),ROW(Table1[Date of Birth])-ROW($C$4)+1,""),ROWS($A$4:A4)),MATCH(G$3,Table1[#Headers],0)),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks