Match two set of numbers to return matched numbers that are in sequence

[lamlam28]

Dear Sir
We have a set of specific numbers that are arranged in sequence.
We want to match these numbers against a 2nd data set to find out the number of matched numbers that are in sequential order.
Please refer to the Excel file for illustration.
Can you help?
Thank you very much!

[Bo_Ry]

Please try at
H17
=MAX(FREQUENCY(C5:C13,IF(COUNTIF(F5:H13,C5:C13)=0,C5:C13)))-1

H22
=INDEX(C5:C13,MATCH(1,FREQUENCY(0,1/(FREQUENCY(-C5:C13,IF(COUNTIF(F5:H13,C5:C13)=0,-C5:C13,-1))+1)),))

H26
=INDEX(C5:C13,MATCH(1,FREQUENCY(0,1/(FREQUENCY(C5:C13,IF(COUNTIF(F5:H13,C5:C13)=0,C5:C13,-1))+1)),))

Ctrl+Shift+Enter

[lamlam28]

Thank you very much.