Formula to count consecutive numbers in each row of a data source

[anonymouspottamus]

What excel formula would I use to count how many consecutive numbers there are in each row of my data source? The data source is A2:E183.

Example:
Row A2 has numbers 13 14 21 28 31
Row A3 has numbers 18 23 29 30 31

How do I find the number of consecutive numbers in row A2?

How do I find the number of consecutive numbers in row A3?

 

[DanteAmor]

According to the following examples, what result do you want in each row:

Libro1
	A	B	C	D	E	F
1
2	13	14	21	28	31
3	18	23	29	30	31
4	10	11	29	30	31
5	10	11	14	30	31
6	1	3	5	7	9
7	1	2	3	4	5
8	10	20	21	22	23
Hoja1

Important: Explain the logic you use to count.

I hope to hear from you soon.
Respectfully
Dante Amor
---------------

 

[anonymouspottamus]

According to the following examples, what result do you want in each row:

Libro1
	A	B	C	D	E	F
1
2	13	14	21	28	31
3	18	23	29	30	31
4	10	11	29	30	31
5	10	11	14	30	31
6	1	3	5	7	9
7	1	2	3	4	5
8	10	20	21	22	23
Hoja1

Important: Explain the logic you use to count.

I hope to hear from you soon.
Respectfully
Dante Amor
---------------

Thank you. I'm trying to count the number of natural consecutive numbers (n+1) that are in each row,
In my data source, no row has more than 3 natural consecutive numbers in it.

In your example:
Row A2 has 2 consecutive numbers
Row A3 has 3 consecutive numbers
Row A4 has 5 consecutive numbers

 

[DanteAmor]

In my data source, no row has more than 3 natural consecutive numbers in it.

So, if it's not too much to ask of you, you could put a representative sample of your information, the result in each row and a description of your logic for counting.

Help us help you by providing complete information.