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

[µo°Ý] ¸õ¦C²Î­p¦³Åã¥Ü"0"ªºÀx¦s®æ¤§Á`­Ó¼Æ

¦^´_ 8# samwang
samwang¤j¤j : ±z¦n !
´ú¸Õ´Á¼Æ¤@¦h¡AVBAªº®Ä²v´N¥YÅã¥X¨Ó¤F
ÁÂÁ±zªºÀ°¦£©M«ü¾É~·P®¦

TOP

¦^´_ 7# ziv976688


   
¦U"³Ì¤p"¦C~³£µLÅã¥Ü"0"­È®É~«hÅã¥Ü""

C26
=IFERROR(1/(1/SUMPRODUCT(SUBTOTAL(2,OFFSET(C47,ROW($1:$1026)*17-17,))*(N(OFFSET(C47,ROW($1:$1026)*17-17,))=0))),"")

©Î
=IF(SUMPRODUCT(SUBTOTAL(2,OFFSET(C47,ROW($1:$1026)*17-17,))*(N(OFFSET(C47,ROW($1:$1026)*17-17,))=0))>0,
  SUMPRODUCT(SUBTOTAL(2,OFFSET(C47,ROW($1:$1026)*17-17,))*(N(OFFSET(C47,ROW($1:$1026)*17-17,))=0)),"")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 9# ML089
ª©¥D : ±z¦n !
·PÁ´£¨Ñ¸ê®Æ·½~¨ü¯q¨}¦h~·P®¦

TOP

¦^´_ 10# samwang
´ú¸Õµ²ªG : §¹¥þ²Å¦X»Ý¨D
ÁÂÁ±zªº­@¤ß«ü¾É©M¼ö¤ßÀ°¦£~·P®¦

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2021-9-29 20:31 ½s¿è

¦^´_ 9# ML089
ª©¥D : ±z¦n !
·PÁ±z´£¨Ñªº¸ê·½(¤£ª¾¹D±z¬OÁä¤J¤°»òÃöÁä¦r?´N¬O¯à§ä¨ì³o¨Çºô¯¸¡A¦Ó§Ú«o§ä¤£¨ì)~
¤ÏÂЬݤF´X¦¸~ÁöµM·wÀYÂà¦V¡A¤£¬O«ÜÀ´(¤£¯à§¹¥þ²z¸Ñ)~¦ý¦Ü¤Öª¾¹D¤½¦¡¸Ó¦p¦ó­l¤Æ¤F¡C

PS¡G
1_¤p§Ìªº1¼Ó´£°Ý¡A¦pªG§ï¬° C26=
¦³Åã¥Ü¼Æ­È®É~«hÅã¥Ü"0"ªº­Ó¼Æ¡F¦pµL"0"­È®É~«hÅã¥Ü" V "¡F¦p³£µLÅã¥Ü­È®É«hÅã¥Ü""
¤p§Ì´N¤£·|³Q2­Ó¤£¦P·N¸qªº"0"·d©ü¤F

2_§Ú¥u·|¥Î2¼hIF¡AÁÙ¤£À´«ç»ò¥Î{ n¡F" V " }

±N¤½¦¡¾ã²z¤F¤@¤U~¦V±z¥æ¤@¥÷²©öªºÅª«á¤ß±o³ø§i:


¨ç¼Æ_¸õ¦C²Î­p«DªÅ¥ÕÀx¦s®æªºÁ`­Ó¼Æ©Î¥[Á`­È.rar (23.93 KB)
¦A¦¸ÁÂÁ±zªº«ü¾É~·P®¦

TOP

¦^´_ 15# ziv976688
¤½¦¡«Üªø®É¡A¥i¥H¥Î ALT-ENTER±N¤½¦¡¤À¬q¡A¦³§U©ó¤F¸Ñ¤ÎDEBUG¡C
¨Ï¥Î¦h¼h IF ®É TRUE¤ÎFALSE¦ì¸m©ñ¸m¤]¥i¥H¦³¤£¦P®ÄªG¡A¦p¤U¨Ò ""¤Î "V"³£©ñ¦bTRUEªº¦ì¸m
§U¤H¬°§Ö¼Ö¤§¥»¡A§Æ±æ¦³À°§U¨ì§A¡C

   
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 16# ML089
ª©¤j : ±z¦n !
ÁÂÁ±z¦A¦¸ªº­@¤ß«ü¾É¥½¾Ç~¨ü´f¨}¦h~·P®¦

TOP

        ÀR«ä¦Û¦b : ¦³´¼¼z¤~¯à¤À¿ëµ½´c¨¸¥¿¡F¦³Á¾µê¤~¯à«Ø¥ß¬üº¡¤H¥Í¡C
ªð¦^¦Cªí ¤W¤@¥DÃD