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

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

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

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

¥¼©R¦W.png
2019-12-12 20:27

´ú¸Õªþ¥óÀÉ¡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))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

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

TOP

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