ML089

¦^´_ 1# lifetw


±N¸ê®Æ¾ã²z½d¨ÒÀÉ¡A­ì©l¸ê®Æ¤Î±ý¾ã²z¦¨ªº¸ê®Æ®æ¦¡¤Î­n¨D

ºÉ¶q§ä¥X¤£¤@¼Ëªº¸ê®Æ®æ¦¡¡A¤~¯à§¹¾ã¦Ò¼{

¤£µM¤Q¸Uµ§§@§¹§A«ç»òª¾¹Dµª®×¬O¹ïªº?

ML089

¦^´_ 4# lifetw

¨S¦³°µ¥X¨Óªº½d¨Ò¥i¥H°Ñ¦Ò

¥u¯à²q·Q¡A½Ð¬Ý¬Ý¹ï¤£¹ï
³B²z¤ñ¹ï.rar (5.07 KB)

¤U¸ü¦¸¼Æ: 5

2015-7-16 22:02

ML089

¦^´_ 6# lifetw

¤U¸ü (150.77 KB)

2015-7-18 00:21

ML089

¦^´_ 9# lifetw

G1 =TRIM(MID(SUBSTITUTE($A1,",",REPT(" ",99)),COLUMN(F1)*99-98,99))
­Y­n¤À¸Ñªº¬OFÄæ
­×§ï¬°
G1 =TRIM(MID(SUBSTITUTE($F1,",",REPT(" ",99)),COLUMN(A1)*99-98,99))

COLUMN(A1) ªí¥Ü¨ú²Ä¤@­Ó¼Æ¦r
·í¤½¦¡¥k©Ô®É¤½¦¡¤¤ªºCOLUMN(A1)·|Åܦ¨COLUMN(B1)¡Aªí¥Ü¨ú²Ä¤G­Ó¼Æ¦r¡A¦A¤S©Ô·|Åܦ¨COLUMN(C1)¡Aªí¥Ü¨ú²Ä°Ñ­Ó¼Æ¦r

ML089

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