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

[µo°Ý] ¨ç¼Æ ©T©w¶¡¹j¦Cªº«ü©w¤å¦r­Ó¼Æ¥[Á`

[µo°Ý] ¨ç¼Æ ©T©w¶¡¹j¦Cªº«ü©w¤å¦r­Ó¼Æ¥[Á`

book_1.rar (5.89 KB)
B2=¥ÑB18¶}©l¨ìB1000,¨C¶¡¹j15¦C¦³Åã¥Ü"¤@"ªº¤å¦r­Ó¼Æ¥[Á`¡A¤½¦¡¥k©Ô¨ìAZ2
B3=¥ÑB19¶}©l¨ìB1000,¨C¶¡¹j15¦C¦³Åã¥Ü"¤G"ªº¤å¦r­Ó¼Æ¥[Á`¡A¤½¦¡¥k©Ô¨ìAZ3
B4=¥ÑB20¶}©l¨ìB1000,¨C¶¡¹j15¦C¦³Åã¥Ü"¤T"ªº¤å¦r­Ó¼Æ¥[Á`¡A¤½¦¡¥k©Ô¨ìAZ4

B6=¥ÑB22¶}©l¨ìB1000,¨C¶¡¹j15¦C¦³Åã¥Ü"¤@"ªº¤å¦r­Ó¼Æ¥[Á`¡A¤½¦¡¥k©Ô¨ìAZ6
B7=¥ÑB23¶}©l¨ìB1000,¨C¶¡¹j15¦C¦³Åã¥Ü"¤G"ªº¤å¦r­Ó¼Æ¥[Á`¡A¤½¦¡¥k©Ô¨ìAZ7
B8=¥ÑB24¶}©l¨ìB1000,¨C¶¡¹j15¦C¦³Åã¥Ü"¤T"ªº¤å¦r­Ó¼Æ¥[Á`¡A¤½¦¡¥k©Ô¨ìAZ8

B10=¥ÑB26¶}©l¨ìB1000,¨C¶¡¹j15¦C¦³Åã¥Ü"¥|"ªº¤å¦r­Ó¼Æ¥[Á`¡A¤½¦¡¥k©Ô¨ìAZ10
B11=¥ÑB27¶}©l¨ìB1000,¨C¶¡¹j15¦C¦³Åã¥Ü"¤­"ªº¤å¦r­Ó¼Æ¥[Á`¡A¤½¦¡¥k©Ô¨ìAZ11
B12=¥ÑB28¶}©l¨ìB1000,¨C¶¡¹j15¦C¦³Åã¥Ü"¤»"ªº¤å¦r­Ó¼Æ¥[Á`¡A¤½¦¡¥k©Ô¨ìAZ12

B14=¥ÑB30¶}©l¨ìB1000,¨C¶¡¹j15¦C¦³Åã¥Ü"¥|"ªº¤å¦r­Ó¼Æ¥[Á`¡A¤½¦¡¥k©Ô¨ìAZ14
B15=¥ÑB31¶}©l¨ìB1000,¨C¶¡¹j15¦C¦³Åã¥Ü"¤­"ªº¤å¦r­Ó¼Æ¥[Á`¡A¤½¦¡¥k©Ô¨ìAZ15
B16=¥ÑB32¶}©l¨ìB1000,¨C¶¡¹j15¦C¦³Åã¥Ü"¤»"ªº¤å¦r­Ó¼Æ¥[Á`¡A¤½¦¡¥k©Ô¨ìAZ16

½Ð°Ý¡G¨ç¼Æ¤½¦¡­n«ç»ò¼g¡H
ÁÂÁ¡I

¥»©«³Ì«á¥Ñ johnny1680 ©ó 2021-9-3 19:19 ½s¿è

¦^´_ 1# johnny1680
Sorry~½d¨Ò¦³¤@¨Çµ§»~
­×¥¿ : ¨ç¼Æ©T©w¶¡¹j¦Cªº¤å¦r­Ó¼Æ¥[Á`.rar (7.5 KB)

TOP

B2
=IFERROR(1/1/COUNT(0/(T(OFFSET(B18,ROW($1:$62)*16-16,))=MID("£¸¤G¤TµL£¸¤G¤TµL¥|¤­¤»µL¥|¤­¤»",ROW(1:1),1))),"")

°}¦C¤½¦¡¡A¤TÁä¿é¤J

"¤@" °ê¦r©Ç©Çªº
¤½¦¡¤¤ªº ¤@¤G¤T¥|¤­¤» ¶·»Pªí®æ¤º¤@­P¡A¦Û¦æ­×¥¿
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# ML089
book3.rar (6.25 KB)
ÁÂÁª©¥DªºÀ°¦£©M¸Ñ´b¡C
©êºp! "¤@"ªº°ê¦r¬O§Úªº¹q¸£¦b¦Û°Ê¿ï¦r¤W·d©Ç¡A©¿¦Ó"¤@"¡A©¿¦Ó"£¸"¡A¨Sª`·N´N¿òº|¤F¡A«Ü¬O·Ð´o¡C

ÁÙ¦³§Úªº­ì»¡©ú¤£«Ü·Ç½T¡A§Úªº»Ý¨D¬O¡G¦b¦U«ü©wªº¶¡¹j¦C¤¤¡A²Î­p"«DªÅ¥Õ"ªºÀx¦s®æ¼Æ¡A
¦pCOUNTAªº²Î­p"«DªÅ¥Õ"ªº­Ó¼Æ¡CEX¡G½d¨ÒªºB&CÄæ
³o¼Ë¤é«á¥H¨C¬P´Áªº¤u§@¤é©Î½s¸¹©Î©m¦W¨Ó²Î­p¥X¶Ô¤H¼Æ³£¥i¾A¥Î¡C

¤£¦n·N«ä¡A§Úªºª©¥»¬OExcel 2003¡A¯à§_·Ð½Ð±z¥H2003ª©¨ç¼Æ§@¸Ñ¡H
ÁÂÁ±z¡I

TOP

¦^´_ 4# johnny1680

B2
=SUMPRODUCT(SUBTOTAL(3,OFFSET(B18,ROW($1:$62)*16-16,)))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# ML089
ÁÂÁª©¥Dªº«ü¾É

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD