ExcelBanter - How do I change data spacing in a column

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I change data spacing in a column (https://www.excelbanter.com/excel-worksheet-functions/57525-how-do-i-change-data-spacing-column.html)

Manthelan

How do I change data spacing in a column

I have 60 000 datapoints in a colum. And I would like to reduce that number
to 3000 by averaging every 20 points. I tried using the average formula but
no success.
Any suggestions?

JE McGimpsey

How do I change data spacing in a column

One way:

B1: =AVERAGE(OFFSET($A$1,(ROW()-1)*20,0,20,1)

Copy down as far as required.

In article ,
Manthelan wrote:

I have 60 000 datapoints in a colum. And I would like to reduce that number
to 3000 by averaging every 20 points. I tried using the average formula but
no success.
Any suggestions?

All times are GMT +1. The time now is 03:07 PM.