Lining up data in Excel

Microsoft Office excel 2007 - upgrade
June 27, 2010 at 23:16:19
Specs: Windows 7
Hi all,

I'm trying to find a way of lining up data with
different scales. An example
will help:

Data 'A' 10.31, 10.147 , 10.147,
10.188, 10.147
Data A Time 0 0.035 0.052
0.123 0.140
Data 'B' 34.75 36.75 35.75 37
Data B Time 0 0.035 0.052
0.0875 0.105

Basically, i'm getting very rapid data from two
non-timesyced devices. In
order to graph and compare these, i need to
as best i can, align the data.
Because there are a few thousand data points,
the small time differences
add up to a big effect.

Is it possible to compare the timestamp of one
dataset (probably the
dataset with the least number of data points),
to the timestamp of the other
and shift the columns across until if finds the
closest match. This way,
every so often there will be gaps in one set of
the data.

Thanks in advance for any help :)


See More: Lining up data in Excel

Report •

June 28, 2010 at 18:01:49
I'm not sure I understand what it is your trying to do.

Your comparing times, but that's about as far as I got.

Can you give an example to what your spreadsheet looks like?

A before and after would be helpful.

Report •
Related Solutions

Ask Question