How do I change data spacing in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
One way:

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

Copy down as far as required.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I have a column of 120 numbers 2
Formula to add two spaces into a number stored as text 3
Non-contiguous range and Sumproduct to average 5
Sum per row and Average per column from a second sheet. 6
X error bar Excel 2007 1
Average across cells with formulas 3
how do i parse every nth data point from a large data set in exce 1
Find the lowest4 numbers of the last 6 in a range 8

Back
Top