ExcelBanter - Counting consecutive numbers in a list

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Counting consecutive numbers in a list (https://www.excelbanter.com/excel-worksheet-functions/253049-counting-consecutive-numbers-list.html)

Wiseguy91

Counting consecutive numbers in a list

I'm looking to take a list of twenty numbers and count the number of times in
that list two or three consecutive numbers appear in it. Any ideas?

T. Valko

Counting consecutive numbers in a list

Can you post some sample data and let us know what result you expect?

--
Biff
Microsoft Excel MVP

"Wiseguy91" wrote in message
...
I'm looking to take a list of twenty numbers and count the number of times
in
that list two or three consecutive numbers appear in it. Any ideas?

All times are GMT +1. The time now is 07:53 AM.