Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I reduce the columns outside my data? | Setting up and Configuration of Excel | |||
average values and reduce and simplify the worksheet | Excel Discussion (Misc queries) | |||
Average 6000 data points in sets of 10 | Excel Worksheet Functions | |||
How do you average more than 30 time points in Excel | Excel Worksheet Functions | |||
How do I reduce the number of data points I have?? | Charts and Charting in Excel |