自动填充公式,是可能吗? [英] Autofilling a formula, is that possible?
问题描述
我有一个非常大的数据文件,所以我不能手动做。这个想法是将一系列数据点扩展到每秒数据点,每秒钟有26个数据点。
到目前为止,我已经尝试过手动,并且只是拖动公式,这是不行的,因为平均值从第2行到第27行,而不是从第26行到第52行。
您的第一行直接自动填写的公式可以是:
= AVERAGE(OFFSET(A $ 1 ,26 *(ROW(1:1)-1),0,26))
I am trying to autofill a formula in Excel. What I mean by that is that I'm trying to have the average of the first 26 rows of a column, then the average of the next 26 rows of the same column, and so on.
I have a pretty large data file, so I can't do it manually. The idea is to scale a series of data points to data points per second, and I have about 26 data points per second.
So far I have already tried doing it manually, and just dragging the formulas down, which doesn't work since the average goes from row 2 to 27 instead of from row 26 to 52, for example.
Your formula for first row to autofill directly can be:
=AVERAGE(OFFSET(A$1,26*(ROW(1:1)-1),0,26))
这篇关于自动填充公式,是可能吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!