ArnoJeroen
New Member
- Joined
- Feb 8, 2018
- Messages
- 1
I have a simple worksheet with a table with 3 columns and >400 rows.
In column A are names (not unique) , in column B are measured values, and in column C I want to have the moving average of the last 8 values of column B
So, in cell C14 the formula is "=average(B7:B14)" or "=subtotal(101;B7:B14)", and in cell C333 the formula is "=average(B326:B333)", etc. , this works fine.
But when I filter the table on a value in column A, I would like to have in column C the moving average calculated on the VISIBLE last 8 values in column B. With the formulas I used, it still calculates with also the invisible values in column B.
How can I get this done the right way?
In column A are names (not unique) , in column B are measured values, and in column C I want to have the moving average of the last 8 values of column B
So, in cell C14 the formula is "=average(B7:B14)" or "=subtotal(101;B7:B14)", and in cell C333 the formula is "=average(B326:B333)", etc. , this works fine.
But when I filter the table on a value in column A, I would like to have in column C the moving average calculated on the VISIBLE last 8 values in column B. With the formulas I used, it still calculates with also the invisible values in column B.
How can I get this done the right way?