[µo°Ý] ¥\¯à°ÝÃD¸ß°Ý

xcz1597534@gmai

°²³]A1~A3¤T­Ó®æ¤l·|ÀH¾÷¶ñ¤J1~5(¥i­«½Æ)
A4­n¿z¿ï¥X1~5­þ­Ó¼Æ¦rÁÙ¨S³Q¥Î¹L
³o¸Ó¥Î­þ­Ó¨ç¼Æ??

xcz1597534@gmai

¸É¥R¤@¤U:
³Ì«áªºµ²ªG¤£¬O¥u¬D¥X¤@­Ó¼Æ¦r´N¦n
¬O©Ò¦³ÁÙ¨S³Q¥Î¨ìªº¼Æ¦r³£­n¬D¥X

mark761222

A4

1. =IF(COUNTIF(A1:A3,1)>=1,"",1)&IF(COUNTIF(A1:A3,2)>=1,"",2)&IF(COUNTIF(A1:A3,3)>=1,"",3)&IF(COUNTIF(A1:A3,4)>=1,"",4)&IF(COUNTIF(A1:A3,5)>=1,"",5)

½Æ»s¥N½X

IF(COUNTIF(A1:A3,1)>=1,"",1)
COUNIF ¦¬¸ß½d³ò1¦³¨S¦³¥X²{¡A¦pªG¥X²{1¦¸¥H¤W¤£Åã¥Ü¡A¨S¥X²{Åã¥Ü1, ¨ä¥L¥þ³¡¥Î&¦ê±µ°_¨Ó

­ã´£³¡ªL

¦^´_ 2# xcz1597534@gmai


¥u¦³¤T®æ¡A¥Î¤T¦¸ªºSUBSTITUTE¨ú¥N§Y¥i¡G
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(12345,A1,""),A2,""),A3,"")

xcz1597534@gmai

·Q½Ð±Ð¨â¦ì¤j¤j¦³¨S¦³§ó²©öªº¤èªk
¦]¬°§Ú¤W­±¥u¬OÁ|¨Ò
¯u¹ê±¡ªp¥i¯à½d³ò·|¨ì¤@¦Ê¦h
³o¼Ë¨ç¦¡·|¼g«Üªø

­ã´£³¡ªL

¦^´_ 5# xcz1597534@gmai


²°Ý²µª, ´£¨Ñ¹ê¨Ò§a!
­nÅý¤½¦¡³sµ²¦r¦ê, ¶µ¥Ø¦h, ¤£¥ÎVBA´N¨S¦³Â²³æªº¤èªk,
³v¤@¦C¥X­Ë¤ñ¸û¥i¦æ, ¨Ò¦p¡G¦C¥X1~39¥¼¥X²{¸¹½X!!

hcm19522

http://blog.xuite.net/hcm19522/twblog/335964037
°Ñ¦Ò

xcz1597534@gmai

¦^´_ 7# hcm19522


    Thanks §Ú¬Ý¬Ý

xcz1597534@gmai

¦^´_ 6# ­ã´£³¡ªL


    ¦n~°²³]´NA1~A100 ·|ÀH¾÷¶ñ¤J1~100¨ä¤¤¤@­Ó¼Æ¦r (¥i­«½Æ)
    A101­n§ä¥X 1~100­þ­Ó¼Æ¦r¨S¥X²{¹L

­ã´£³¡ªL

¦^´_ 9# xcz1597534@gmai

¢Ð¢°¡D°}¦C¤½¦¡¡G¤U©Ô¢°¢¯¢¯®æ¡A¨S¥X²{ªº³v¤@¦C¥X
=TEXT(SMALL(IF(ISNA(RANK(ROW($1:$100),A$1:A$100)),ROW($1:$100),999),ROW(A1)),"[<101]0;")

©Î¡G¢Ð¢°¬°³Ì«áµ²ªG¡A¤U©Ô¢°¢¯¢¯®æ¡A¼Æ¦r¥HªÅ¥Õ¤À¹j
=TRIM(TEXT(SMALL(IF(ISNA(RANK(ROW($1:$100),A$1:A$100)),ROW($1:$100),999),ROW(A1)),"[<101]0;")&" "&B2)

·Q¤@­Ó¤½¦¡¦b¤@­ÓÀx¦s®æ±o¥Xµ²ªG¡A¥ÎVBA§a¡ã¡ã