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

[µo°Ý] ²¾°£­«ÂÐ

[µo°Ý] ²¾°£­«ÂÐ

½Ð°Ý¤@¤U¦U¦ì¤j¤j.. «ç¼Ë¥i¥H¦b¤@¤j½d³ò¸Ì²¾°£­«ÂЩO..

remove

remove repeat2.jpg
2017-11-15 15:27


Åܦ¨§ä¨ì¥H¤Uµ²ªG:
item        ¦¸¼Æ
eleven        6
two             3
thirty           3
(¦¸§Ç¤£¥Î¶¶§Ç)
(¦¸¼Æ¥i§ä¥X¤]¥i¥H¤£§ä¥X)
(¥Øªº¬O­n§ä¥XitemªºªF¦è)

ÁÂÁ¦U¦ì¤j¤jÀ°¦£~ ¸U¤À·PÁÂ~~~

¥»©«³Ì«á¥Ñ Airman ©ó 2017-11-17 20:28 ½s¿è

¦^´_ 3# jomeow

¤£¦n·N«ä¡Aı±o­nÅý§Ú¸ÑÄÀ¡A­Ë¤£¦p°Ñ¾\.microsoft.comªº»¡©ú¨Óªº¹ê»Ú @~@~
EX:
INDIRECT¨ç¼Æ~½Ð°Ñ¦Ò
https://support.microsoft.com/zh-tw/help/213933/how-to-use-the-indirect-function-to-create-references-in-excel

TEXT¨ç¼Æ~½Ð°Ñ¦Ò
https://support.office.com/zh-tw/article/TEXT-%E5%87%BD%E6%95%B8-20d5ac4d-7b94-49fd-bb38-93d29371225c

¨ä¥L¨ç¼Æªº¥Îªk¦³¤£À´ªº¦a¤è~Google¤@¤U´N¦³«Ü¦h»¡©ú¤F

¤]¥i¥H¦b½s¿è¦C¿ï¨ú¤½¦¡ªº¬Y¤ù¬q~«öF8¬Ý°õ¦æµ²ªG~¬Ý¨C¤@­Ó¤£¦PªºÀx¦s®æ¡A¦b¦P¬Y¤ù¬qªº¤½¦¡¡A¨äµ²ªG²£¥Íªº®t²§©MÅܤÆ~À³¸Ó·|¤ñ¥Î¤å¦r¸ÑÄÀ§ó¯à¥O¤H¦³©ÒÅé·|¡C

PS:  {1,2,3,4}  ´N¬OA:D¥|­ÓÄ檺¥N½X(ÃѧO½X)¡A¦pªG¥u¤ñ¹ïA,B¤GÄ檺½d³ò¡A´N§ï¦¨  {1,2}

¥H¤W¨Ñ°Ñ

TOP

¦^´_ 2# Airman


ÁÂÁÂAirman¤j¤jÀ°¦£..
§Ú¥i¥H¦h°Ý¤@¤U.. ½Ð°Ý«ç¸ÑÄÀ©O.. §Ú¬Ý¤£©ú¥Õ..
=INDIRECT(TEXT(MIN(IF(COUNTIF(F$1:F1,TEXT(A$1:D$15,F$1)),4^8,ROW($1:$15))*10+{1,2,3,4}),"!R0C0"),)&""

©êºp.. ¤p©f¤Ó²Â..

TOP

¥»©«³Ì«á¥Ñ Airman ©ó 2017-11-16 15:28 ½s¿è

¦^´_ 1# jomeow

²¾°£­«ÂÐ.png
2017-11-16 15:10


F2
=INDIRECT(TEXT(MIN(IF(COUNTIF(F$1:F1,TEXT(A$1:D$15,F$1)),4^8,ROW($1:$15))*10+{1,2,3,4}),"!R0C0"),)&""
°}¦C¤½¦¡(¿é¤J¤½¦¡«á¡A¦b½s¿è¦C¤º¦P®É«öCTRL+SHIFT+ENTER ¤TÁä)
¤U©Ô¶ñº¡¡C

G2
=IF(F2<>"",COUNTIF(A:D,F2),"")
¤U©Ô¶ñº¡¡C

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD