EXCEL里,如何在A列里选择部门后,在B列自动列出对应部门的人以便选择答:部门数据验证设置:=$A$1:$C$1 2. 人员数据验证设置:=INDIRECT(CHOOSE(MATCH(E1,$A$1:$C$1,),"A","B","C")&"2:"&CHOOSE(MATCH(E1,$A$1:$C$1,),"A","B","C")&"5")3. 效果如下图所示:
excelA列、B列对应不同数据,把同A列的B列全部数据在C列显示答:C1:=IF(COUNTIF(A$1:A1,A1)=1,PHONETIC(OFFSET(A$1,MATCH(A1,A:A,0)-1,1,COUNTIF(A:A,A1))),"")=== =IF(COUNTIF(A$1:A1,A1)=1,PHONETIC(OFFSET(A$1,MATCH(A1,A:A,0)-1,1,COUNTIF(A:A,A1))),"")