½Ð°Ý¦U¦ì«e½úºô¸ô§ì¤Uªº¸ê®Æ¦³ªÅ®æ¡A¦p¦ó³B²z¤ñ¹ï
- ©«¤l
- 24
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- pro
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2015-7-13
- ³Ì«áµn¿ý
- 2015-9-19
|
¥»©«³Ì«á¥Ñ lifetw ©ó 2015-7-19 11:14 ½s¿è
¦^´_ 10# ML089
MLª©¥D¤j¤j±z¦n
·PÁÂÀ°¦£¡A
쥻¸ê®Æ¤À´²¦hÄæ¡A©Ò¥H¦pªGcopy ¦Ü¦P¤@Äæ¡A´N4Äæ«Ý³B²z¡AÁÂÁÂ!!
=COUNT(0/(MMULT(--ISNUMBER(FIND(B1:E1,Sheet2!B$1:B$50)),{1;1;1;1})=4))
³o³¡¤À¯à½ÐMLª©¥D¤j¤j¶}¥Ü¤@¤U¶Ü? COUNTpºâ½d³ò¤¤§t¦³¼Æ¦rªºÀx¦s®æÁ`¼Æ¡ACOUNT¤§«á¬O¦p¦ó¤ñ¹ï¬Û¦P©O?
¬Ý¤F¦U¨ç¼Æ»¡©úÁÙ¬O«Ü¼Ò½k...¯S§O¬O{1;1;1;1}=4¡A¤£ª¾¦p¦ó¬d°_!!
³sµ²¬O·L³n©xºô»¡©ú¡AÀ³¸Ó¦w¥þ
FIND ¨ç¼Æ
ISNUMBER ¨ç¼Æ
MMULT ¨ç¼Æ
COUNT ¨ç¼Æ
«D±`ÁÂÁÂÀ°¦£¡A·PÁÂ!! |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
     
|
¦^´_ 11# lifetw
=COUNT(0/(MMULT(--ISNUMBER(FIND(B1:E1,Sheet2!B$1:B$50)),{1;1;1;1})=4))
¤½¦¡pºâ¨BÆJ
¨BÆJ1¡A¥HB1:E1¬d¸ßSheet2!B$1:B$50¬O§_¦s¦b¡A²£¥Í4¦æ*50¦C°}¦C¸ê®Æ
FIND(B1:E1,Sheet2!B$1:B$50)
¨BÆJ2¡A¦³¬d¨ìªº¸ê®ÆÂର1¡A¨S¦³¬d¨ìªº¸ê®ÆÂର0
--ISNUMBER(FIND(B1:E1,Sheet2!B$1:B$50))
¨BÆJ3¡A±N4¦æ*50¦C°}¦C¸ê®Æ¨Ï¥ÎMMULTÂର1¦æ*50¦C¸ê®Æ
MMULT(--ISNUMBER(FIND(B1:E1,Sheet2!B$1:B$50)),{1;1;1;1})
¨BÆJ4¡A1¦æ*50¦C¸ê®ÆY¼ÆȬ°4®Éªí¥Ü4Ó¥þ³¡¦³¬d¨ì¡C
MMULT(--ISNUMBER(FIND(B1:E1,Sheet2!B$1:B$50)),{1;1;1;1})=4
¨BÆJ5¡A0/TRUE=0¡A 0/FALSE=#DIV/0!
0/(MMULT(--ISNUMBER(FIND(B1:E1,Sheet2!B$1:B$50)),{1;1;1;1})=4)
¨BÆJ6¡A COUNT §Q¥Î0/(...)pºâ¥X¦³¦h¤ÖTRUEªº¼Æ¶q
=COUNT(0/(MMULT(--ISNUMBER(FIND(B1:E1,Sheet2!B$1:B$50)),{1;1;1;1})=4))
¤jP¸ÑÄÀ¡A¤½¦¡»¡©ú¦Û¦æ¬d¸ßHELP |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 24
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- pro
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2015-7-13
- ³Ì«áµn¿ý
- 2015-9-19
|
¦^´_ 12# ML089
MLª©¥D¤j¤j±z¦n
¸Ñ»¡¤w¸g«D±`¸Ô²Ó¡A§Ú·|¥J²Ó¸ÑŪ¸Õ§@
«D±`ÁÂÁ¼·¤¾À°¦£¡A·PÁÂ!!! |
|
|
|
|
|
|