| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
merging data sets using dates
Hi:
You can do that by using the Vlookup fuction as follow: Vlookup(Lookup Value,Table array, Colum Index (Return), Range Lookup) Range Lookup MUST be equal to TRUE. This will return the closest value matched. Argy "Scubaseth" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel graph 3 sets of data. 2 sets as lines 1 as column? | Charts and Charting in Excel | |||
| Merging to data sets | Excel Worksheet Functions | |||
| merging two sets of data | Excel Discussion (Misc queries) | |||
| Working with data sets with disparate dates | Excel Discussion (Misc queries) | |||
| Merging 2 sets of data | Excel Worksheet Functions | |||
Hybrid Mode
