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

¨Ì¾Ú¤£¦Pªº¨Ó·½Key­È§O¡A°µ5¦¸ªº²¾°Ê¥­§¡¡C

¨Ì¾Ú¤£¦Pªº¨Ó·½Key­È§O¡A°µ5¦¸ªº²¾°Ê¥­§¡¡C

§Ç¸¹        ¤º®e        ©Ò¨D
0        ¨Ì¾Ú¤£¦Pªº¨Ó·½Key­È§O¡A°µ5¦¸ªº²¾°Ê¥­§¡¡C¡C       
1        ­n°µ5¦¸ªº²¾°Ê¥­§¡¡C       
2        ¥ý°µ¥¿±`ªº²¾°Ê¥­§¡¡A¡u²³æ²¾°Ê¥­§¡_05¡v¡C§Q¥Î Offest »P Average ¨ç¼Æ¬°¤§¡C       
3        ³o­Ó¥Î¤H¤u¿z¿ïªº¤è¦¡¡u²¾°Ê¥­§¡_05_¨Ì¾Ú¨Ó·½§O¡v¡C¥Î¤â¤u¬°¤§¡C       
4        ¡u²³æ²¾°Ê¥­§¡_05¡vªº³¡¤À¡A«e4¶µ¡]n-1¡^¡AÁÙ¬O¨Ï¥Î¤â¤uªº¤è¦¡¬°¤§¡A¦³§_ª½±µªº¤½¦¡¬°¤§¡C->¦³§_¤£¥Î¤H¤u§PÂ_¤½¦¡
5        ¡u²³æ²¾°Ê¥­§¡_05¡vªº³¡¤À¡A«e4¶µ¡]n-1¡^¡AÁÙ¬O¨Ï¥Î¤â¤uªº¤è¦¡¬°¤§¡A¦³§_ª½±µªº¤½¦¡¬°¤§¡C->¦³§_¤£¥Î¤H¤u§PÂ_¤½¦¡

²¾°Ê¥­§¡.zip (6.18 KB)

¤w¦³¸Ñµª¡A¬O§_ÁÙ¦³«Øijªº¸Ñµª¡C

²¾°Ê¥­§¡_¸Ñµª01.zip (5.5 KB)

TOP

¦^´_ 2# Baracuda
=IF(COUNTIF($B$2:B2,B2)>4,AVERAGE(OFFSET(C2,,,-5,)),"")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

Hsieh :ÁÂÁ¡A³o­Ó·| Work¡A§Aªº¤èªk¤ñ¸û¦n¡C

TOP

        ÀR«ä¦Û¦b : ÀR§¤±`®¦¤v¹L¡B¶¢½Í²ö½×¤H«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD