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

[µo°Ý] ´M§ä«e¯S©wµ§¼Æªº³Ì¤j­È

[µo°Ý] ´M§ä«e¯S©wµ§¼Æªº³Ì¤j­È

¥»©«³Ì«á¥Ñ cslu37 ©ó 2019-3-13 20:04 ½s¿è

§äEÄæ¡A«e5µ§³Ì¤j­È ¡÷ Y2=5

=MAX(OFFSET(E3,0,0,-$Y$2,1))

1¡B½Ð°Ý¬°¦ó $Y$2 «e­±­n¥[­t¸¹©O¡H
2¡B½Ð°Ý¦pªG­n§äEÄæ¡A«e6~10µ§ªº³Ì¤j­È¡A­n¦p¦ó¼g©O¡H

·Ð¦U¦ì°ª¤âÀ°¦£¡AÁÂÁ¡I

§äEÄæ¡A«e5µ§³Ì¤j­È ¡÷ Y2=5

=MAX(OFFSET(E3,0,0,-$Y$2,1))

1¡B½Ð°Ý¬°¦ó $Y$2 «e­±­n¥[­t¸¹©O¡H
³o¬O¨ç¼Æªº©w¸q¡A¥¿¼Æ©¹«á¡A­t¼Æ©¹«e

2¡B½Ð°Ý¦pªG­n§äEÄæ¡A«e6~10µ§ªº³Ì¤j­È¡A­n¦p¦ó¼g©O¡H
=LARGE(E:E,row(a1))
¤U©Ô¡A²Ä¤@­Ó³Ì¤j¡A¦A¨Ó¦¸¤§¡A....
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089

ÁÂÁ±z~­ì¨Ó¥¿­t¸¹¬O³o­Ó·N«ä^^~


¦ý²Ä¤G­Ó°ÝÃD¡A
¦]¬°¸ê®Æ¦³´X¤dµ§¡A­n§ä·íµ§ ©¹«e±À6~10µ§¤¤ ªº ³Ì¤j­È
½Ð°Ý­n¦p¦ó¼g©O@@?

PS¡G¸ê®Æ¨C5¤ÀÄÁ·s¼W¤@µ§  ´N­n­«·s­pºâ  ©¹«e±À6~10µ§¤¤ ªº ³Ì¤j­È

TOP

¦^´_ 3# cslu37


A1 =20-ROW(A1)
¤U©Ô
B10 =MAX(OFFSET(A10, -5, 0, -5))
¤U©Ô

¤p´ú¸Õ¡A¬Ý¬Ýµ²ªG¡A¦A¬Ý¬Ý¨ç¼Æ»¡©ú¡AÀ³¸Ó´N¯à©ú¥Õ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

·PÁ¤j¤jÀ°¦£~~~
§Ú¬O·s¤â...³£ºN¤£µÛÀYºü...«Ü¦h¨ç¼Æ¡B¨ç¼Æªº»¡©ú³£¬Ý¤£À´>"<
¦£¨ì­è­è¤]¼g¤£¥X©Ò¥HµM....©ú¤Ñ¦­°_Ä~Äò§V¤O!!

TOP

¦^´_ 5# cslu37


    OFFSET(¦ì¸m¡A1(Y¦V:¥¿+©¹¤U¡F­t-©¹¤W)¡A2(X¦V¡G¥¿+©¹¥k¡G­t-©¹¥ª)¡A3(Yªø¡G¥¿+©¹¤U¡G­t-©¹¤W)¡A4(Xªø¡G¥¿+©¹¥k¡G­t-©¹¥ª) )
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# ML089

Excel¥»¨­ªº¨ç¼Æ»¡©ú¡A³£¤å¨¥¤å¡A®Ú¥»¬Ý¤£À´>"<

ÁÂÁ¤j¤j~»¡©ú«Ü²M·¡¡A²×©óÀ´¤F¬O¤°»ò·N«ä¤F¡AÀò¯q¨}¦h!!¯uªº¬O¤Ó·PÁ¤F~~~

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD