If two cells in column A and B are the same then count the sequence in column C

[WillTempo]

Hello,

I have looked but cannot find the answer to my question. I need a formula that looks at the data in column H and then at the data in column I, if the data in the two rows are the same it then will count if the numbers are sequential in column K. For example in the attached screen shot, rows 27 and 28 both have the same figures for H and I and the data in I, is sequential so i would like to return a 1 in column K. There could be up to 6 sequential numbers.

Many thanks for any help.

 

[Peter_SSs]

Welcome to the MrExcel board!

For the future, please consider this so helpers can copy your sample data to test with:
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Is this what you mean?
If not please provide some sample data again and include the expected results (& preferably post it with XL2BB)

22 03 10.xlsm
	H	I	J	K
1
2	263	1	7
3	265	6	7
4	266	3	7
5	510	6	9
6	510	3	9	1
7	510	3	10	1
8	600	5	1
9	600	4	2	1
10	600	4	3	1
11	600	4	4	1
12	600	4	5	1
13
Seq

Cell Formulas
Range	Formula
K2:K12	K2	=IF(OR(AND(H2=H1,I2=I1,J2=J1+1),AND(H2=H3,I2=I3,J2=J3-1)),1,"")

 

[WillTempo]

That is brilliant. Thank you for your help

 

[Peter_SSs]

Cheers, glad to help. Thanks for the follow-up.