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

[µo°Ý] ²¤¹LªÅ¥Õ¦V¥ª¶ñº¡ªº¨ç¼Æ¤½¦¡

[µo°Ý] ²¤¹LªÅ¥Õ¦V¥ª¶ñº¡ªº¨ç¼Æ¤½¦¡

²¤¹LªÅ¥Õ¦V¥ª¶ñº¡.rar (29.79 KB)
¤£¦n·N«ä¡Aª¦¤å³\¤[¡A¥u¦³¦bGoogle§ä¨ìB75ªº¤½¦¡¡A
¥i§_½Ð¦U¦ì¤j¤jÀ°¦£«ü¾ÉB74©MB75¦X¨Ö»Ý¨DªºB77¤½¦¡¡HÁÂÁ¡I

Sheet1!B74="¦U¤p­p¦C(8¦C,15¦C,...63¦C,70¦C)10­Ó¹ï¨¤°Ï"ªº³Ì¤j¼Æ¡C
Sheet1!B75=B74¦CªºÁY±Æ¡C

Sheet2!B74="²Ä72¦C(Á`­p¦C)10­Ó¦U§À¼Æ°Ï"ªº³Ì¤j¼Æ¡C
Sheet2!B75=B74¦CªºÁY±Æ¡C

½Ð±ÐSheet1!B77"©MSheet2!B77"¤£¥Î»²§U¦C"ªºExcel2003ª©¨ç¼Æ¤½¦¡¡CÁÂÁ¡I

=MAX(OFFSET($B1,COLUMN(A1)*7-(COLUMN(A1)>9),COLUMN(A1)*5-5,,5))

TOP

¦^´_ 2# ­ã´£³¡ªL
ª©¥D¤j¤j :
·PÁ±zªºÀ°¦£©M½ç±Ð^^
½Ð°Ý:Sheet1!B77©¹¥k©Ô®É¡A·|Åã¥Ü"0"ªº³¡¤ÀÀx¦s®æ¡A­n¦p¦óÅã¥Ü"ªÅ¥Õ"?
ÁÂÁ±z^^

Sheet2!B77¯à§_·Ð½Ð±z¤@¨Ö½ç±Ð?
ÁÂÁ±z^^

TOP

¦^´_ 2# ­ã´£³¡ªL
ª©¥D¤j¤j :
½Ð°Ý:Sheet1!B77©¹¥k©Ô®É¡A®ø°£"0"Åã¥Ü"ªÅ¥Õ"¡A§Ú¥u·|¤gªk·Ò¿û~
=IF(MAX(OFFSET($B1,COLUMN(A1)*7-(COLUMN(A1)>9),COLUMN(A1)*5-5,,5))<>0,MAX(OFFSET($B1,COLUMN(A1)*7-(COLUMN(A1)>9),COLUMN(A1)*5-5,,5)),"")

Sheet2!B77¯à§_·Ð½Ð±z¦A¦¸½ç±Ð?
ÁÂÁ±z^^

TOP

¦^´_ 4# papaya


¤£¬O¥u¦³10°Ï, ¦ó¥²¦h©Ô¦ÓÅã¥Ü0

TOP

¦^´_ 5# ­ã´£³¡ªL
ª©¥D¤j¤j :
²z½×¤W¬O10°Ï¨S¦³¿ù¡A¦ý¸U¤@¦³¬Y°Ïªº³Ì¤j¼Æ¦³1­Ó¬Û¦P­È¥H¤W®É¡A´N·|¦h¥X10­Ó^^"

¦]¬°5¼Óªº¦^ÂСA¤p§Ì¤~µo²{¤½¦¡µLªkÅã¥Ü"·í¬Y°Ï¦³1­Ó¥H¤W¬Û¦Pªº³Ì¤j­È"¡A¯à§_½Ð±z­×¥¿?
ÁÂÁ±z^^

TOP

¦^´_ 6# papaya

­Y¤@°Ï¦³¦h­Ó³Ì¤j­È, ¨º¥H¤W¤½¦¡µL®Ä,
¤]·Q¤£¥X¤èªk¥h¨ú~~

TOP

¦^´_ 7# ­ã´£³¡ªL
ª©¥D¤j¤j :
¨S¦³Ãö«Y¡A´N¥u¦n¥Î­ì¨Ó¦³»²§U¦Cªº¤½¦¡^^"
¦]¬°¨C1­Ó¤ñ¹ïºØÃþ¤½¦¡¡A¨S¦³»²§U¦Cªº¤½¦¡¹ï¤ñ¦³»²§U¦Cªº¤½¦¡¡A´N¯à¬Ù14¦C¡A¦bÂsÄýªºª©­±·|¬Ù²¤«Ü¦h¡A¤è«K³\¦h~©Ò¥H¤~·|·Q½Ð±Ð^^
¦A¦¸ÁÂÁ±zªº¼ö¤ß«ü¾É©MÀ°¦£~·P®¦^^

TOP

        ÀR«ä¦Û¦b : Ä@­n¤j¡B§Ó­n°í¡B®ð­n¬X¡B¤ß­n²Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD