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

[µo°Ý] ¤@¦¡§¹¦¨ªº¤½¦¡¡C

[µo°Ý] ¤@¦¡§¹¦¨ªº¤½¦¡¡C

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2019-12-12 20:36 ½s¿è


´ú¸Õªþ¥óÀÉ¡J ¤@¦¡§¹¦¨ªº¤½¦¡¡C.rar (4.54 KB)

BZ3
=($BO3¡J$BX3)ªº³Ì¤j¼Æ­È¡C

CA3
=($BO10¡J$BX10)ªº³Ì¤j¼Æ­È¡C

CB3
=($BO17¡J$BX17)ªº³Ì¤j¼Æ­È¡C

¨ä¾lCC3¡JCI3¥H¦¹Ãþ±À¡C


½Ð°Ý¡JBZ3:CI3=·j´M$BO3¡J$BX66¨C¸õ7¦Cªº¦U³æ¦C³Ì¤j­Èªº¤@¦¡§¹¦¨ªºExcel 2003ª©¨ç¼Æ¤½¦¡¡AÀ³¸Ó¦p¦ó½s¼g¡H
·Ð½Ð¦U¦ì¤j¤jÀ°¦£¡IÁÂÁ¡I

MAX(OFFSET($BO3,COLUMN(A1)*7-7,,,10))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522
h¤j¤j :
ÁÂÁ±zªºÀ°¦£©M«ü¾É!
·P®¦:D

TOP

        ÀR«ä¦Û¦b : ¯à¥I¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD