Finding Sequences and Highlighting them in different ways

Hello everyone.

i was wondering how to go about finding sequences and highlighting them.

here's an example list:

7600
7601
7602
7603
7604
7608
7609
7610
7611

now i need to find 3 things in this list.

1) how many 'batches' of sequences there are in this list. The numbers 7600 to 7604 are a consecutive sequence of five numbers followed by another sequence from 7608 to 7611. that makes two sequences. i need a formula for one cell that would specify how many sequences there are in a given list (in this case they're two sequences in this list).

2) is there any formula that can allow me to see each sequence highlighted in a different color (or any way to differentiate the sequences so i can copy paste them easily?). Pretty sure i'd have to use conditional formating on the entire list to do so but am clueless as to the implementation.

3) a formula for a single cell that can state the largest sequence in the list. in the list above the largest seuqnce is 5 numbers so that would be the value i'm looking for.

Conditional formatting from A2 downwards

in A2 =IF(A2=A1+1) set one colour else set another colour
This will highlight the change start of sequences but not the entire sequence themselves but its a start

Assuming that A2:A10 contains the data, the data does not contain duplicates, and the data is sorted in ascending order, try...

To count the number of consecutive occurrences:

Please Login or Register  to view this content.

To return the maximum consecutive occurrence:

Please Login or Register  to view this content.

Hope this helps!

for number 3
=MAX(FREQUENCY(IF(IF(ABS(A1:A99-A2:A100)=1,1,0)=1,ROW(A1:A99)),IF(IF(ABS(A1:A99-A2:A100)=1,1,0)<>1,ROW(A1:A99))))+1
array entered will return count of longest seq in range a1:a100 adjust range to suit

well you could do as in attached but if two sequences follow each other it will highlite both together but it may help .two ways shown 1/ 2 /3 series or alternatively a 3/2/1 sequence

thought of away of highliting first one of each sequence to be a different colour than rest of sequence
see attached each dark green is start of new sequence