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

[µo°Ý] OFFSET»yªk

[µo°Ý] OFFSET»yªk

¥»©«³Ì«á¥Ñ papaya ©ó 2017-11-22 23:24 ½s¿è

SHEET1.png
2017-11-22 23:17


OFFSET»yªk¡J(reference,rows,cols,height,width)
reference=$A$7
rows=0
cols=0
height=21
width=1

B1
=OFFSET($A$7,,,COUNT(A:A)-3,1)=$A$4

$A$7°_ºâªº21¦C¤¤¡A¦³²Ä17¦C=$A$4=199
B1«ç»ò·|Åã¥ÜFALSE
½Ð°Ý:
B1ªº¤½¦¡­þ¸Ì¿ù¤F?
ÁÂÁÂ¥ý!

TEST-1.rar (7.74 KB)

¦^´_ 1# papaya

©êºp!²{¦b¤~µo²{©ñ¿ù¹ÏÀɤF^^"
§ó¥¿:
TEST-1.png
2017-11-23 00:14

TOP

¦^´_ 1# papaya


   
2017-11-23_093045.png
2017-11-23 09:31

TOP

¦^´_ 3# joblyc017
J¤j:±z¦n!
­ì¨ÓÁÙ­n¥[OR¨ç¼Æ¡A¤½¦¡¤~§¹¾ã¡C
·PÁ±z¦h¦¸­@¤ß¼·¤¾«ü¾É^^

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD