當月生日人員 (Birthday person of the month) (11918)

G2:H7{=INDEX(B:B,SMALL(IF(TEXT($C$2:$C$99,"M")=TEXT($E$2,"M"),ROW($2:$99),99),ROW(A1)))&""

格式化 B2:C21=COUNTIF($G:$G,$B2)