|
|
#1
03-26-2013, 02:00 AM
|
|||
|
|||
formulae to combine excel records
I have the following example - date & time, value
01.01.2013 22:02:02.157 1.32068 01.01.2013 22:02:15.028 1.3207 01.01.2013 22:03:01.673 1.3205 01.01.2013 22:03:01.732 1.32044 01.01.2013 22:03:01.792 1.32043 01.01.2013 22:03:02.092 1.32075 01.01.2013 22:03:02.397 1.32075 01.01.2013 22:03:07.233 1.32056 01.01.2013 22:03:14.262 1.32056 01.01.2013 22:03:14.582 1.32053 01.01.2013 22:05:11.892 1.32062 01.01.2013 22:05:12.546 1.32062 -------------------------------------- I wish to produce a second sheet like..... 01.01.2013 22:02 value1 01.01.2013 22:03 value2 01.01.2013 22:05 value3 where values1, 2 and 3 are the average of all the values from 22:02, 22:03 and 22:05 Any suggestions on a logical way to approach this problem? 
|
| Tags |
| aggregating data |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Loss of formulae values when mail merging excel to word | MellowMel | Mail Merge | 6 | 05-09-2014 09:08 AM |
| Excel 2007-How to merge multiple records into one | mag | Excel Programming | 1 | 11-21-2012 12:11 AM |
 Use NUMPAGES in formulae
|
Friedebarth | Word | 1 | 11-30-2011 02:22 PM |
|
Combine Records when Mail Merge from Access
|
Tom Pickles | Misc | 2 | 08-24-2010 06:00 PM |
| Why wont my simple formulae work? | Florish | Excel | 4 | 02-17-2009 07:33 AM |
Windows 7 32bit 
Office 2007
Threaded Mode