On 4/17/2013 7:20 AM, XLT_Frank wrote: > Morning. I am looking to determine if interop1 is the best method for > the following: > > data1 has two columns, time1 and sensor value. the intervals are on > demand with 4000+ rows > > data2 has two columns, time2 and sensor value. the intervals are at 20Hz > with 32,000+ rows > > I want to take data2 and realign with data1 because I only need to know > the sensor values in data2 when the sensor value in data1 occurs. Is > this method also okay when dealing with floating point values for my > time code (still deciding on format of time vs. date vs. time and date > serial).
I'd instead use the integer sampling rate as the time instead of float since you want an exact comparison and that's iffy w/ floating point and then use ISMEMBER or INTERSECT.