办公软件EXCEL表格技巧,请问怎样自动刷出新进员工和离职员工?谢谢

2022-11-14 04:13发布

(离职人员列)数组公式: =INDEX(A:A,SMALL(IF(COUNTIF(B:B,$A$2:$A$99),4^8,ROW($A$2:$A$99)),RO

(离职人员列)数组公式: =INDEX(A:A,SMALL(IF(COUNTIF(B:B,$A$2:$A$99),4^8,ROW($A$2:$A$99)),RO