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

[µo°Ý] ¦p¦ó­pºâ¯B°Ê¦C¼Æ½d³òªº¥­§¡­È

¦^´_ 10# Hsieh

ÁÂÁ ¶W¯Åª©¥D ªº«üÂI
§Ú¸ÕµÛ¨Ì·Ó ¶W¯Åª©¥D ªº«ü¥Ü¶i¦æ x©w¸q½d³ò¤½¦¡ªº­×§ï¡Aµ²ªGÁÙ¬O¦³°ÝÃD
±µµÛ§Úµo²{ ¥u­n±N yªº©w¸q½d³ò¤½¦¡­×§ï¡A·f°t ¶W¯Åª©¥D ©Ò´£¨Ñªº x ­×§ï¡Aµ²ªG´NOK
­×§ï«e y¤½¦¡ =OFFSET(´ú¸Õ!$C$14,,,COUNTA(´ú¸Õ!$E14:$E$65536)+1,)
­×§ï«á y¤½¦¡ =OFFSET(´ú¸Õ!$C$14,,,COUNTA(´ú¸Õ!$E14:$E$65536)+ROW(´ú¸Õ!E14),)

¦]¬°¹ï¤½¦¡¨Ã¨S¦³§¹¥þ¤F¸Ñ³z´ú¡A©Ò¥H¤]¤£¤Óª¾¨ä©Ò¥HµM
ªþ¤W­×§ï«áªº´ú¸Õµ²ªG¥¿±`ÀɮסA¦pªG¦³¥ô¦ó¸É¥R»¡©ú¡A½Ð¤£§[´£¥X¡AÁÂÁÂ

JS

´ú¸Õ2.zip (30.11 KB)

TOP

¦^´_ 11# jsleee
y¤½¦¡ =OFFSET(´ú¸Õ!$C$14,,,COUNTA(´ú¸Õ!$E$14:$E$65536)+1,)
¦C¦ìÀ³¸Ó­n¥Îµ´¹ï°Ñ·Ó¡A§_«h·í¦WºÙ¨Ï¥Î©ó¤½¦¡¤º®É
·|¦]¬°¨î§ïÅܦӧïÅÜ­pºâªº°_©l¦ì¸m
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 12# Hsieh

·PÁ ¶W¯Åª©¥D ´£¨Ñªº­×¥¿
¤w­×¥¿¨Ã´ú¸Õ¥¿±`¡A·P®¦

JS

TOP

¤½¦¡¤w³]°ÊºA¤F,¥t¥~¼W¥[¤@ VBA  ³t«×¸ò®Ä²v³£¥þ­±´£¤É,½Ð°Ñ¦Òªþ¤WªºÀÉ®×

¯B°Ê¦C¼Æ­pºâ.rar (9.28 KB)

300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 14# zz5151353

·PÁ zz¤j¤jªº¨ó§U¡A§Ú¦A¦n¦n¬ã¨s¬ã¨s

JS

TOP

j14
=IF(C14="","",PRODUCT(OFFSET(I14,,,IF(ISNA(MATCH("*",C15:C$99,)),COUNT(E14:E$99),MATCH("*",C15:C$99,)))))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí ¤W¤@¥DÃD