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

[µo°Ý] ¤U©Ô¦¡¿ï³æ¹ï·Ó²Ö¥[

[µo°Ý] ¤U©Ô¦¡¿ï³æ¹ï·Ó²Ö¥[

2014«n³¡·|­û±¡³ø¦¬¶°-Keyin¥Î.ZIP.zip (11.9 KB)




¤p§Ì·Q²Î­p¨C¤ë¨C¶g­û¤u¥Ç¿ù²Î­pªí

¦p¹Ï:"1¤ë"¸ê®Æªí¸Ì²Ä¤@©P(1/4~1/10)¡A¤p§Ì·Q¦A"¿é¤JªÌ"¿ï¾Ü­û¤u©m¦W«á¡A¹ïÀ³¨ì"²Î­pªí"¸ê®Æªí¸Ì«ö¶g²Î­p¥X¼Æ­È

½Ð°Ý¤j¤j¦³¤°»ò¤è¦¡¥i¥H³]©w©O~"~??


½Ð¤j¤jÀ°¦£¸Ñµª
¤£·|EXCALLªº²Â³J

¦^´_ 1# prince0413
¥Î¤½¦¡¡A²Î­pªí B4  =COUNTIF(OFFSET('1¤ë'!$C$5,15*(ROW()-4),,10,1),B$3)
¦V¥k¦V¤U¶ñº¡

TOP

¦^´_ 2# stillfish00

¤j¤j±z¦n¡G

B4  =COUNTIF(OFFSET('1¤ë'!$C$5,15*(ROW()-4),,10,1),B$3)


¨º­Ó¤¤¶¡15*(ROW()-4)   ¨º­Ó15¬O¤£¬O§ï¦¨14¤]¥i¥H?
¬O¥Nªí¿z¿ïªºÀx¦s®æ½d³ò¶Ü?
¤£·|EXCALLªº²Â³J

TOP

¥»©«³Ì«á¥Ñ stillfish00 ©ó 2014-1-7 19:41 ½s¿è

¦^´_ 3# prince0413
§A¥ý¬Ý¤@¤U¤½¦¡ OFFSET(reference, rows, cols, [height], [width]) ªº¥Îªk§a!
¬°¤°»ò­n§ï14¡A§A1¤ëªº¤u§@ªí®æ¦¡·|ÅÜ?

15*0¡A15*1¡A15*2ªí¥Ü
C5©¹¤U²¾°Ê0 -> C5
C5©¹¤U²¾°Ê15 -> C20
C5©¹¤U²¾°Ê30 -> C35

TOP

¦^´_ 4# stillfish00

¤j¤j±z¦n¡G
§Ú¤F¸Ñ¤F~
¥Ø«e¬O¦ôºâ¦h¤@ÂI®æ¤l¡A¦pªGª¾«á¦³ÅܰʼW¥[ªº¸Ü¡A´N¦b§ï¨º­Ó­È¹ï§a(¼W¥[¤@®æ´NÅÜ"16*")¡A¬O³o¼Ë¶Ü??

ÁÂÁ±zªºÀ°¦£
¤£·|EXCALLªº²Â³J

TOP

¦^´_ 5# prince0413
[height] ªº10¤]­nª`·N...

TOP

¦^´_ 6# stillfish00

¦³¥hoffice©xºô¬doffsetªº½d¨Ò¤F
¦]¬°­ì¥»¤£¸Ñªº¬O¬°¤°»ò¨C­ÓÀx¦s®æ¤½¦¡³£¤@¼Ë¡A«o¯à°÷¦Û¤v§PÂ_¶g§O¹ïÀ³¨ì¸ÓÀx¦s®æ
¸g¤j¤j¸ÑÄÀ«á²{¦bÁA¸Ñ¤F

ÁÂÁ¤j¤jªº±Ð¾É^^
¤£·|EXCALLªº²Â³J

TOP

¦^´_ 6# stillfish00

2014«n³¡·|­û±¡³ø¦¬¶°-Keyin¥Î.zip.zip (18.21 KB)
   
¤j¤j±z¦n¡G

§Ú¦³¥é·Ó1¤ëªº¸ê®Æªí¦b·s¼W¤@­Ó2¤ëªº¸ê®Æªí©M²Î­pªí
¦ý¬O2¤ë²Î­pªí«o¨S¦³¶]¥X­È¡A¬O³]©wªº°ÝÃD¶Ü~"~?
¤£·|EXCALLªº²Â³J

TOP

¥»©«³Ì«á¥Ñ aer ©ó 2014-1-14 16:48 ½s¿è

¦^´_ 8# prince0413
½Ð­×§ï2¤ë¤½¦¡¦p¤U
=COUNTIF(OFFSET('2¤ë'!$C$5,15*(ROW()-11),,10,1),B$3)
¦V¥k¦V¤U½Æ»s

TOP

¦^´_ 8# prince0413
B11  =COUNTIF(OFFSET('2¤ë'!$C$5,15*(ROW()-11),,10,1),B$3)
¦V¥k¦V¤U¶ñº¡

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD