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.
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.