Excel提取AB两列中不重复的值,并把数据复制到C列?

2025-04-06 13:50:48
推荐回答(1个)
回答1:

如图C2=IFERROR(INDIRECT(TEXT(MIN(IF((COUNTIF($C$1:C1,$A$2:$B$7)=0)*($A$2:$B$7<>""),ROW($A$2:$B$7)*100+COLUMN($A$2:$B$7),"")),"R0C00"),),""),按CTRL+SHIFT+ENTER结束公式.