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

¦p¦ó¨ú³Ì«á6­Ó¤ëªº¸ê®Æ

¦p¦ó¨ú³Ì«á6­Ó¤ëªº¸ê®Æ

ªþ¥óÀɮפ¤, ¹Ïªí¥u»Ý§e²{³Ì«á6­Ó¤ë¸ê°T.
½Ð°Ý¹Ïªíªºdata°Ï¦p¦óalways§ì¨ú³Ì«á6­Ó¤ëªº¼Æ¦r?
·PÁÂ

¨ú³Ì«á6­Ó¤ëªº¸ê®Æ.zip (15.97 KB)

fangac

¦^´_ 1# fangsc
Àx¦s®æC2=OFFSET($B$24,,COUNTA(24:24)-7+COLUMN(A$1))
Àx¦s®æC3=INDEX($B$25:$Y$46,$A$3,COUNTA(24:24)-6+COLUMN(A$1))
¦V¥k½Æ»s
½Ð°Ñ¦Ò¡I

TOP

·PÁÂp212 ¤j¤j´£¨Ñ¤è¦¡
C3¤§  $Y$46 À³§ï¬° $IV$46 ¥H§Q·s¼WÄæ¦ì®É¥i§ì¨ú¨ìDATA.

=INDEX($B$25IV$46,$A$3,COUNTA(24:24)-6+COLUMN(A$1))
ù

TOP

¦^´_ 3# rouber590324

·PÁ¤G¦ìªº¸Ñµª. :)
fangac

TOP

        ÀR«ä¦Û¦b : ¦Û¤v®`¦Û¤v¡A²ö¹L©ó¶ÃµoµÊ®ð¡C
ªð¦^¦Cªí ¤W¤@¥DÃD