Thread: How do I change data spacing in a column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Manthelan
 
Posts: n/a
Default 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?
Reply With QuoteReply With Quote