Excel怎么提取出不重复名字
1、打开Excel文档
3、选择E2单元格，输入公式：=INDIRECT(TEXT(MIN((COUNTIF(E$1:E1,$A$2:$C$5)+(A$2:C$5<=""))/1%%+ROW(A$2:C$5)/1%+COLUMN(A$2:C$5)),"R0C00"),)&""
5、把E2单元格的公式拖动复制到E10单元格，提出了所有不重复的名字
1、打开Excel文档
3、选择E2单元格，输入公式：=INDIRECT(TEXT(MIN((COUNTIF(E$1:E1,$A$2:$C$5)+(A$2:C$5<=""))/1%%+ROW(A$2:C$5)/1%+COLUMN(A$2:C$5)),"R0C00"),)&""
5、把E2单元格的公式拖动复制到E10单元格，提出了所有不重复的名字