I have several spreadsheets of data that are timestamped. The data should be continuous, and each of the sheets should overlap somewhat.
However, when the data was pulled, the time stamps were wiped, and all the data has the same starting timestamp, which it should not. I know the ending time stamp, and can back calculate the presumed times for all data points, but this doesn't quite line up right.
What I am trying to do is to identify the place in the first series of data that correlates to the first X data points in the second series of data.
For example, if X = 5, I want to identify the place in column C where 4 consecutive values correlate in order with the first 4 values of column E.
The output should tell me that this occurs in row 6 in the following example
I think this should be an Index-Match, but can't figure out how to get that to work.
However, when the data was pulled, the time stamps were wiped, and all the data has the same starting timestamp, which it should not. I know the ending time stamp, and can back calculate the presumed times for all data points, but this doesn't quite line up right.
What I am trying to do is to identify the place in the first series of data that correlates to the first X data points in the second series of data.
For example, if X = 5, I want to identify the place in column C where 4 consecutive values correlate in order with the first 4 values of column E.
The output should tell me that this occurs in row 6 in the following example
I think this should be an Index-Match, but can't figure out how to get that to work.
1 | 12:30 | 5 | 12 | |
2 | 12:31 | 4 | 3 | |
3 | 12:32 | 2 | 18 | |
4 | 12:33 | 9 | 4 | |
5 | 12:34 | 7 | 3 | |
6 | 12:35 | 12 | 5 | |
7 | 12:36 | 3 | 7 | |
8 | 12:37 | 18 | 7 | |
9 | 12:38 | 4 | 6 | |
10 | 12:39 | 3 | 9 |