Data Filtering:

F

Fifi

I have a 14,000 points data (time and pressure) from an instrument.
have a second set of data 10,000 points from another instrumen
measuring similar process on the same equipment but have a differen
sampling rate. I need to match the first set of data (14,000) to th
second (10,000) by throwing away those data points in the 14,000 point
data set whose time stamp are not the same as that of the time stamp i
the 10,000 points data. The result will a condensed 10,000 points dat
for both instrument that captures the same event at the same time o
both instuments. any help will be appreciated. The attached file is
sample of the data. The whole file is too big to be attached

Attachment filename: points1.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=63030
 
F

Fifi

Frank, thanks for your help. I tried the attached link but its not doin
what I looking for. What I want is a way to match time in column A (sa
cell A3) to the same time in column B which may be in say cell B12. S
I will end up with a data in column C with a condensed time stam
derived from column B and the corresponding event value in column D
Your link was very helpful. I will aprreciate any help
 
F

Fifi

I made some progress by using the formul
IF(COULNTIF($A$2:$A$5000,B2:5500)>0,B2,"FALSE"). It works and returne
that is on the cell in which the formula is true. But I want it t
return the cell in which the match is found that may I could know wha
the data at that time match. Can anybody help. I think all need to kno
is how to return the cell row & column
 
Top