Find specific series of values in a list

bigmyk2k

Board Regular
Joined
Feb 9, 2012
Messages
102
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.

112:30512
212:3143
312:32218
412:3394
512:3473
612:35125
712:3637
812:37187
912:3846
1012:3939
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

JamesCanale

Board Regular
Joined
Jan 13, 2021
Messages
200
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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!","")
 
Solution

Watch MrExcel Video

Forum statistics

Threads
1,133,271
Messages
5,657,764
Members
418,411
Latest member
Excellency

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top