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 |
Solved! Go to Solution.
A Multi-Row formula should work for this.
Note - I added a value for Customer 33359 with a row of 34 into your data to confirm it worked for 4 sequential numbers
The multi row formula worked perfectly. Thank you.
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |