View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arvin Lab Rat
 
Posts: n/a
Default thin # of samples by averaging

I have large columns of data (4000 to 5000 entrys) I would like to thin the
data out or reduce the number of samples by building a new column of groups
of average values. For example:
3 reduce by average groups of 3 3
3 5
3 7
4
5
6
7
7
7
If any one can offer some advise
Thanks in advance