ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

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

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

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

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

TOP

¥»©«³Ì«á¥Ñ mark761222 ©ó 2015-11-10 00:30 ½s¿è

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¥þ³¡¥Î&¦ê±µ°_¨Ó

TOP

¦^´_ 2# xcz1597534@gmai


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

TOP

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

TOP

¦^´_ 5# xcz1597534@gmai


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

TOP

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

TOP

¦^´_ 7# hcm19522


    Thanks §Ú¬Ý¬Ý

TOP

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


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

TOP

¦^´_ 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¡ã¡ã

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD