排序 只分男女 (14442)

D2:E8=IF(LEFT(D$1)=$B2,COUNTIFS($B:$B,LEFT(D$1),$C:$C,">"&$C2)+1,"")



留言