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

2023-07-26 11:42发布

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

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