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

½Ð°Ý¦U¦ì«e½úºô¸ô§ì¤Uªº¸ê®Æ¦³ªÅ®æ¡A¦p¦ó³B²z¤ñ¹ï

¥»©«³Ì«á¥Ñ 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¶Ü?  COUNT­pºâ½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ÁÂ!!

TOP

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

¤j­P¸ÑÄÀ¡A¤½¦¡»¡©ú¦Û¦æ¬d¸ßHELP
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 12# ML089
MLª©¥D¤j¤j±z¦n
¸Ñ»¡¤w¸g«D±`¸Ô²Ó¡A§Ú·|¥J²Ó¸ÑŪ¸Õ§@

«D±`ÁÂÁ¼·¤¾À°¦£¡A·PÁÂ!!!

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD