B列为原始名单
D列为签到栏
=IF(COUNTIF($D$2:$D$302,B2)>0,COUNTIF($D$2:$D$302,B2),"")

标签: none

评论已关闭