Posted to microsoft.public.excel.misc

Scubaseth

external usenet poster

Posts: 1

merging data sets using dates

I have two data sets.
Each is two columns. Date/time and temp.
First data set has readings at intervals of 5- 15 minutes.
Second data set has reading every 30 minutes.

I would like to match, to the closest date and time, the second set to the
first.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Excel graph 3 sets of data. 2 sets as lines 1 as column?	AndyN	Charts and Charting in Excel	2	July 11th 08 01:18 PM
Merging to data sets	Arun Kumar Saha	Excel Worksheet Functions	0	September 19th 07 05:04 PM
merging two sets of data	spud	Excel Discussion (Misc queries)	2	June 14th 07 08:49 PM
Working with data sets with disparate dates	JP[_2_]	Excel Discussion (Misc queries)	0	May 1st 07 09:17 PM
Merging 2 sets of data	ALEX	Excel Worksheet Functions	1	February 1st 07 06:25 PM

All times are GMT +1. The time now is 03:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us