LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 5
Default reduce data points and average?

hello all, here's the isse:

column A : time, formatted in dd/mm/yyyy mm:ss
column B : a numerical value (3.30, 3.31...)

As you can see below I have 6 of these numerical value entry per minute. I would like to reduce them to 1 entry per minute, and this entry should be the average of the 6 ; what do you recommend? thank you!!

07/05/2012 00:01 3.30
07/05/2012 00:01 3.31
07/05/2012 00:01 3.33
07/05/2012 00:01 3.33
07/05/2012 00:01 3.33
07/05/2012 00:01 3.31
07/05/2012 00:02 3.34
07/05/2012 00:02 3.37
07/05/2012 00:02 3.36
07/05/2012 00:02 3.34
07/05/2012 00:02 3.34
07/05/2012 00:02 3.32
07/05/2012 00:03 3.32
07/05/2012 00:03 3.28
07/05/2012 00:03 3.28
07/05/2012 00:03 3.31
07/05/2012 00:03 3.32
07/05/2012 00:03 3.29
07/05/2012 00:04 3.29
07/05/2012 00:04 3.31
07/05/2012 00:04 3.32
07/05/2012 00:04 3.29
07/05/2012 00:04 3.29
07/05/2012 00:04 3.29
07/05/2012 00:05 3.27
07/05/2012 00:05 3.29
07/05/2012 00:05 3.31
07/05/2012 00:05 3.31
07/05/2012 00:05 3.32
07/05/2012 00:05 3.30
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I reduce the columns outside my data? JFort Setting up and Configuration of Excel 2 September 15th 09 06:32 PM
average values and reduce and simplify the worksheet Omics Excel Discussion (Misc queries) 2 May 22nd 08 08:57 AM
Average 6000 data points in sets of 10 Vikash Excel Worksheet Functions 2 April 26th 07 04:02 PM
How do you average more than 30 time points in Excel LoriG Excel Worksheet Functions 4 July 27th 06 08:32 PM
How do I reduce the number of data points I have?? ssanjan Charts and Charting in Excel 1 July 31st 05 05:32 AM


All times are GMT +1. The time now is 09:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"