# Find specific series of values in a list

#### bigmyk2k

##### Board Regular
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.

 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

### Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

#### JamesCanale

##### Board Regular
Try:
MrExcelPlayground2.xlsx
ABCDEF
1112:305 1212,3,18,4
2212:314 3
3312:322 18
4412:339 4
5512:347 3
6612:3512HERE IT IS!5
7712:363 7
8812:3718 7
9912:384 6
101012:393 9
Sheet3
Cell Formulas
RangeFormula
D1:D10D1=IF(CONCATENATE(C1,",",C2,",",C3,",",C4)=F\$1,"HERE IT IS!","")

Replies
2
Views
91
Replies
7
Views
101
Replies
4
Views
214
Replies
4
Views
119
Replies
0
Views
34

1,133,617
Messages
5,659,882
Members
418,535
Latest member
Ajith55

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back