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

[µo°Ý] ¤½¦¡¤¤,°Ñ·Ó½d³òÅÜ´«

[µo°Ý] ¤½¦¡¤¤,°Ñ·Ó½d³òÅÜ´«

¤j®a¦n, §Ú¦³¤@­Ó°ÝÃD.
¦pªG§Ú­n­pºâ¤@¦C¼Æªº¥­§¡¼Æ®É,  ¨Ò¦p¥»¨Ó§Ú­n1-3¦æªº¥­§¡¼Æ.
«á¨Ó§Ú·Q§ï­n1-5, ¦³¤èªk¥i¥H¤£¥Î¤H¤â©Ô½d³òªº±¡ªp¤U, Åܰʽd³ò¶Ü?

¦]¬°§Ú¦³250ºØ½d³ò­n°µ........¤H¤â¯uªº·|¦º.....

ªþ¤W¨Ò¤lÀÉ

1.png (51.25 KB)

1.png

¥»©«³Ì«á¥Ñ ML089 ©ó 2016-4-11 14:55 ½s¿è

¦^´_ 1# monkey1gb

C2 =IFERROR(AVERAGE(OFFSET($A2,,,-COLUMN(B2))),"")
©Î
C2 =IFERROR(AVERAGE(OFFSET($A2,,,-C$1)),"")

¥k©Ô¦ÜH¡A¦A¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_  monkey1gb

C2 =IFERROR(AVERAGE(OFFSET($A2,,,-COLUMN(B2))),"")
©Î
C2 =IFERROR(AVERAGE(OFFS ...
ML089 µoªí©ó 2016-4-11 14:32



    ½Ð°Ýª©¥D¤j¤j,  ¨º§Ú¦b­þ¸Ì¥i¥H¿é¤J¼Æ¦r§ï½d³ò??

TOP

¦^´_ 3# monkey1gb

K1 ¿é¤J¼Æ¦r
K2 =IFERROR(AVERAGE(OFFSET($A2,,,-K$1)),"")
¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_  monkey1gb

K1 ¿é¤J¼Æ¦r
K2 =IFERROR(AVERAGE(OFFSET($A2,,,-K$1)),"")
¤U©Ô
ML089 µoªí©ó 2016-4-11 14:54



ª©¤j¦n§Q®`!!!
   
¥i¬O....¤£¦n·N«ä, §Ú¤S¹J¨ì¥t¤@­Ó°ÝÃD

2.png (33.56 KB)

2.png

TOP

¦^´_ 5# monkey1gb


K1 ¿é¤J¼Æ¦r
K2 =IFERROR(AVERAGE(OFFSET($A2,,,-K$1)),"")
¤U©Ô


­Y­n©ñ¦bK5®æ¹ïÀ³A5
K5  =IFERROR(AVERAGE(OFFSET($A5,,,-K$1)),"")

§A¥i¥H¤ñ¸û¤W¤U¨â¦¡®t²§
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_  monkey1gb


K1 ¿é¤J¼Æ¦r
K2 =IFERROR(AVERAGE(OFFSET($A2,,,-K$1)),"")
¤U©Ô


­Y­n©ñ¦bK ...
ML089 µoªí©ó 2016-4-11 16:30


ª©¤j, §Ú¸Õ¹L§A¤W­±ªº¤½¦¡¤F, ¥i¬O¨S¦³®t§O????
¥t¥~§Ú¬ã¨s¤F¤@°}¤l, °ÝÃDÁٸѨM¤£¨ì.....
¨D±Ð

3.png (40.77 KB)

3.png

TOP

¦^´_ 7# monkey1gb

K2 =IF(ROW()<K$1+1,"",AVERAGE(OFFSET($A2,,,-K$1)))
¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_  monkey1gb

K2 =IF(ROW()
ML089 µoªí©ó 2016-4-11 17:26



  ¶W·P¿Eªº, ÁÂÁª©¤j

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD