คำตอบที่ได้รับเลือกจากเจ้าของกระทู้
ความคิดเห็นที่ 1
C2
=IF(AND(ISNUMBER(FIND("0",A2)),ISNUMBER(FIND("0",B2))),"0","")
&IF(AND(ISNUMBER(FIND("1",A2)),ISNUMBER(FIND("1",B2))),"1","")
&IF(AND(ISNUMBER(FIND("2",A2)),ISNUMBER(FIND("2",B2))),"2","")
&IF(AND(ISNUMBER(FIND("3",A2)),ISNUMBER(FIND("3",B2))),"3","")
&IF(AND(ISNUMBER(FIND("4",A2)),ISNUMBER(FIND("4",B2))),"4","")
&IF(AND(ISNUMBER(FIND("5",A2)),ISNUMBER(FIND("5",B2))),"5","")
&IF(AND(ISNUMBER(FIND("6",A2)),ISNUMBER(FIND("6",B2))),"6","")
&IF(AND(ISNUMBER(FIND("7",A2)),ISNUMBER(FIND("7",B2))),"7","")
&IF(AND(ISNUMBER(FIND("8",A2)),ISNUMBER(FIND("8",B2))),"8","")
&IF(AND(ISNUMBER(FIND("9",A2)),ISNUMBER(FIND("9",B2))),"9","")
D2
=IF(OR(ISNUMBER(FIND("0",A2)),ISNUMBER(FIND("0",B2))),"0","")
&IF(OR(ISNUMBER(FIND("1",A2)),ISNUMBER(FIND("1",B2))),"1","")
&IF(OR(ISNUMBER(FIND("2",A2)),ISNUMBER(FIND("2",B2))),"2","")
&IF(OR(ISNUMBER(FIND("3",A2)),ISNUMBER(FIND("3",B2))),"3","")
&IF(OR(ISNUMBER(FIND("4",A2)),ISNUMBER(FIND("4",B2))),"4","")
&IF(OR(ISNUMBER(FIND("5",A2)),ISNUMBER(FIND("5",B2))),"5","")
&IF(OR(ISNUMBER(FIND("6",A2)),ISNUMBER(FIND("6",B2))),"6","")
&IF(OR(ISNUMBER(FIND("7",A2)),ISNUMBER(FIND("7",B2))),"7","")
&IF(OR(ISNUMBER(FIND("8",A2)),ISNUMBER(FIND("8",B2))),"8","")
&IF(OR(ISNUMBER(FIND("9",A2)),ISNUMBER(FIND("9",B2))),"9","")
E2
=SUBSTITUTE(D2,C2,"")
C2
=IF(AND(ISNUMBER(FIND("0",A2)),ISNUMBER(FIND("0",B2))),"0","")
&IF(AND(ISNUMBER(FIND("1",A2)),ISNUMBER(FIND("1",B2))),"1","")
&IF(AND(ISNUMBER(FIND("2",A2)),ISNUMBER(FIND("2",B2))),"2","")
&IF(AND(ISNUMBER(FIND("3",A2)),ISNUMBER(FIND("3",B2))),"3","")
&IF(AND(ISNUMBER(FIND("4",A2)),ISNUMBER(FIND("4",B2))),"4","")
&IF(AND(ISNUMBER(FIND("5",A2)),ISNUMBER(FIND("5",B2))),"5","")
&IF(AND(ISNUMBER(FIND("6",A2)),ISNUMBER(FIND("6",B2))),"6","")
&IF(AND(ISNUMBER(FIND("7",A2)),ISNUMBER(FIND("7",B2))),"7","")
&IF(AND(ISNUMBER(FIND("8",A2)),ISNUMBER(FIND("8",B2))),"8","")
&IF(AND(ISNUMBER(FIND("9",A2)),ISNUMBER(FIND("9",B2))),"9","")
D2
=IF(OR(ISNUMBER(FIND("0",A2)),ISNUMBER(FIND("0",B2))),"0","")
&IF(OR(ISNUMBER(FIND("1",A2)),ISNUMBER(FIND("1",B2))),"1","")
&IF(OR(ISNUMBER(FIND("2",A2)),ISNUMBER(FIND("2",B2))),"2","")
&IF(OR(ISNUMBER(FIND("3",A2)),ISNUMBER(FIND("3",B2))),"3","")
&IF(OR(ISNUMBER(FIND("4",A2)),ISNUMBER(FIND("4",B2))),"4","")
&IF(OR(ISNUMBER(FIND("5",A2)),ISNUMBER(FIND("5",B2))),"5","")
&IF(OR(ISNUMBER(FIND("6",A2)),ISNUMBER(FIND("6",B2))),"6","")
&IF(OR(ISNUMBER(FIND("7",A2)),ISNUMBER(FIND("7",B2))),"7","")
&IF(OR(ISNUMBER(FIND("8",A2)),ISNUMBER(FIND("8",B2))),"8","")
&IF(OR(ISNUMBER(FIND("9",A2)),ISNUMBER(FIND("9",B2))),"9","")
E2
=SUBSTITUTE(D2,C2,"")
แสดงความคิดเห็น
ดึงเลขซ้ำและไม่ซ้ำกันออกมา
พอทราบมั๊ยครับว่าต้องใช้สูตรอะไรบ้าง
ขอเบอร์ prompay ด้วยนะครับ มีค่ากาแฟให้ครับผม
ขอบพระคุณอย่างสูงเลยครับ