在Excel中,怎样删除重复的数字,只保留不重复的数字(重复的数字一个都不保留),如何用表达式?如何所示,A1、A2、
A3都有重复的数字,B1等于0,B2等于6,B3等于28,如何用公式来删除重复数字,只保留不重复的数字?
å ¬å¼æç¹å¤æï¼ä¸å¦ææ°å0åªæä¸ä¸ªï¼åªææ¾å¨æåé¢ææåé¢ãå¦å¾ï¼å ¬å¼ï¼
B1=SUBSTITUTE(SUM(IFERROR((FREQUENCY(-MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),-MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))=1)*MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),0)*10^((LEN(A1)+1-ROW(INDIRECT("1:"&LEN(A1)+1))))),0,"")&IF(LEN(A1)-LEN(SUBSTITUTE(A1,0,""))=1,0,"")
åæ¶æCtrl+Shift+Enterä¸é®è¾å ¥æ°ç»å ¬å¼ï¼ä¸æ
追çç¨Excel 365æExcel2019çè¶ çº§ææ¬è¿æ¥å½æ°åå ¬å¼ç®åå¾å¤ï¼ä¸ä¸é´çå个æ°å0å¯ä»¥æ顺åºååºï¼å¦å¾Cåå³ä¸ºç¨è¶ 级æ件è¿æ¥å½æ°å¾å°çç»æï¼å ¬å¼ï¼
C1=TEXTJOIN(,1,IF(FREQUENCY(-MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),-MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))=1,MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),""))
åæ¶æCtrl+Shift+Enterä¸é®è¾å ¥æ°ç»å ¬å¼ï¼ä¸æã
é常æ谢大ç¥çææã大ç¥ï¼å¯ä»¥å请æä¸ä¸é®é¢åï¼å¯ä»¥ç§èåï¼