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

[µo°Ý] ¦³Ãö§ä´M¨C¤Ñ·|­û½s¸¹°ÝÃD

[µo°Ý] ¦³Ãö§ä´M¨C¤Ñ·|­û½s¸¹°ÝÃD

¦U¦ì¤j¤j§A­Ì¦n..

·Q½Ð±Ð.. §Ú¨C¤Ñ³£·|¦¬¨ì·í¤Ñ«È¤H¥X¤J¦¸¼Æªº¬ö¿ý.. ¦³¤£¦P·|­û½s¸¹.. ¦Ó·|­û¥i¥H¦P¤@¤é¥X²{¤@¦¸©Î¥H¤W..
§Ú¨C¬P´Á­n°µÁ`ªí°O¿ý¦³¤°»ò·|­û½s¸¹¦b¤@¬P´Á¸Ì¥X¤Jªº¦¸¼Æ..

§Úªº°ÝÃD¨Ó¤F.. ¦b·|­û¸ê®Æ¸Ì..§ÚÁ`¦@¦¬60000¸U·|­û..
¦ý¥X²{ªº¦³¥i¯à¥u¬OÁ`¼Æªº30%...
§Ú«ç¥i¥H¥Î§ó§Öªº¤èªk§ä¥X¦b³o¬P´Á¸Ì¥X²{ªº·|­û½s¸¹.. µM«á¦A°µ¥XÁ`ªí­pºâ¥L­Ì¨C¦ì·|­û¥X¤Jªº¦¸¼Æ©O..

·Q½Ð±Ð¦U¦ì¤j¤j¥X¤âÀ°§U...

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

60000¸U·|­û * ¤é´Á¼Æ ³o¬O¤Ñ¤å¼Æ¦r

¼Æ¶q«Ü¦hªº²Î­p³Ì¦n¦³¬YºØ±Æ¦C¶¶§Ç¤~·|§Ö
¨Ò¦p ¥H¤é´Á±Æ¦C¤§²Î­p¡A¥i¥H¥ý§ä¨ì°_©l¤é¦ì¸m¤Î²×¤î¤é¦ì¸m¡A¥u²Î­p¦¹¬q¸ê®Æ¥i¥H¥[³t²Î­p¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

§ÚÁ`¦@¦¬60000¸U·|­û..
¦ý¥X²{ªº¦³¥i¯à¥u¬OÁ`¼Æªº30%...

¨º¦Ü¤Ö¤]¦³¤W¸Uµ§¸ê®Æ, ¦ó¤£¤W¶ÇÀÉ®×, ¥i¯à¥ÎVBA¸û¾A¦X!

TOP

¦U¦ì¦n... §Ú¦b³o¨à§ä¨ì¤Fµª®×.. ¥ÎCOUNTIF + MATCH...
¤£¹L.. §Úªº°ÝÃD¤S¨Ó¤F..
¦³¨ÇITEM... §Ú¥ÎMATCH¬O§ä¤£¨ì¥X¨Ó.. ½Ð°Ý¬O¤£¬O¦³²Å¸¹ªº°ÝÃD? ½Ð°Ý¥i¥H«ç¸Ñ¨M©O?

ÁÂÁ¦U¦ì¤j¤j¥X¤âÀ°§U..

¦^ÂÐ¥H¤W¤j¤jªº°ÝÃD.. ¦]¬°§Ú¤£À´¥ÎVBA.. ©Ò¥H¥u¥i¥H¥Î¤½¦¡¨Ó³B²z..  ><
countif match na.rar (11.07 KB)

TOP

¤j¤j§A¦n.. §Ú¤W¶Ç¤FFILE..
ÁÂÁ¤j¤jÀ°¦£¸Ñ¨M..  ­«ÂЪºITEM¥u­n²Ä¤@­Ó/¤@­Ó..  
¥t¥~.. ¤é´Á¥i¤£¥i¥H¥Î²³æ¤èªk¨Ó¨ú®ø¤é´Á¸Ìªº®É¶¡...

ÁÂÁ¦U¦ìÀ°¦£...

countif match na.rar (152.63 KB)

§ÚÁ`¦@¦¬60000¸U·|­û..
¦ý¥X²{ªº¦³¥i¯à¥u¬OÁ`¼Æªº30%...

¨º¦Ü¤Ö¤]¦³¤W¸Uµ§¸ê®Æ, ¦ó¤£¤W¶ÇÀÉ®×, ¥i¯à¥Î ...
­ã´£³¡ªL µoªí©ó 2018-3-31 11:35

TOP

¦^´_ 6# jomeow


D3:
=IF(B3="","",IF(ROW()=MATCH(SUBSTITUTE(B3,"~","~~"),B:B,),B3,""))

³æ­Ó"~"µLªk§@¬°[¯Á¤Þ­È], ¥²¶·¦A¥[¤@¦¸"~", Åܦ¨"~~"
¨ä¥¦¦p"?","*", ­Y­n·í§@[¤å¦r]¨Ó¤ñ¹ï¬d¸ß, ¤]³£­nÅܧ@"~?","~*", §_«h·|·í§@¼Ò½k§ä¬d!

TOP

²{¦b©ú¥Õ¤F.. §Ú­è­è¸Õ¹L.. ¦¨¥\¤F..
ÁÂÁ¤j¤jÀ°¦£§r..
\(^O^)/

¦^´_  jomeow


D3:
=IF(B3="","",IF(ROW()=MATCH(SUBSTITUTE(B3,"~","~~"),B:B,),B3,""))

³æ­Ó"~ ...
­ã´£³¡ªL µoªí©ó 2018-4-6 12:42

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD