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

[µo°Ý] ¦p¦ó¦Û°Ê§ì¨ú«ü©w¤Ñ¼Æ­pºâ?

[µo°Ý] ¦p¦ó¦Û°Ê§ì¨ú«ü©w¤Ñ¼Æ­pºâ?

¦pªþÀÉ¡AÁÂÁ¦U¦ì¤j¤jÅo! help1.rar (7.8 KB)

B2¿é¤J
=IF(ROW()<$B$1+1,"",AVERAGE(OFFSET(A2,,,-$B$1)))
©¹¤U©Ô

TOP

=IF(ROW()>B$1,AVERAGE(INDIRECT("A"&ROW()-2&":A"&ROW())),"")

TOP

«¢«¢«¢¡A¯u¬O¼F®`¡AÁÂÁ±z¤F!

TOP

        ÀR«ä¦Û¦b : «H¤ß¡B¼Ý¤O¡B«i®ð¤TªÌ¨ã³Æ¡A«h¤Ñ¤U¨S¦³°µ¤£¦¨ªº¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD