MrExcel Publishing
Your One Stop for Excel Tips & Solutions

data point reduction


Posted by jochen on November 13, 2001 6:20 AM

My problem is the following one:
I will reduce the nummber of data I have:
for instance:
I have 6000 data points and I will reduce it to
the average of each ten data points, so that I have
at the end 600 data poins.
Is it possible to do this????


Posted by Juan Pablo on November 13, 2001 7:48 AM

If your data starts in Row 2, you can copy this formula and drag down. It'll give you the average of every 10 data points, and blank for the rest. Then, copy and paste as values, select special (F5), blank cells, delete, shift up, and you have the data "condensed".

=IF(MOD(ROW()-1,10)=0,IF(ROW()>=10,AVERAGE(INDIRECT("A"&ROW()&":A"&ROW()-9)),""),"")

Juan Pablo