How to count sequential groupings

[ktberger_2020]

Can someone please help me figure out how to count the number of times a unique entity has a sequential count? It does not matter how long any sequence is, as long as it is 2 or more.

In the example below, the desired result for Customer 33359 would be a count of 3 and for Customer 12345, the count would be 2. 

Store	Customer	PaymentRow
C0299	33359	9
C0299	33359	10
C0299	33359	11
C0299	33359	22
C0299	33359	23
C0299	33359	31
C0299	33359	32
C0299	33359	33
C0299	12345	16
C0299	12345	17
C0299	12345	28
C0299	12345	29

[Carolyn · Accepted solution]

A Multi-Row formula should work for this. 

1. I created a new column called "Sequential?" in the Multi-Row Tool.
2. For the logic: if the Payment Row is 1 more than the Prior Row AND it's not 2 more than the 2-Prior Row, put 1. Otherwise put 0
   1. The "not 2 more" piece is so if you have 3 or more consecutive values, you get the 1 for the first set of consecutive values and then 0 after that, so you only count it once
3. Summarize Tool to total up the "Sequential?" column

Note - I added a value for Customer 33359 with a row of 34 into your data to confirm it worked for 4 sequential numbers

 

[nagakavyasri]

@ktberger_2020 another way:

[ktberger_2020]

The multi row formula worked perfectly. Thank you.