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/253052-counting-consecutive-numbers-list.html)

Wiseguy91

Counting consecutive numbers in a list

Is there a function that will take a list of 20 numbers and count if two or
three of them are consecutive and count how many times this happens within
the list?

All times are GMT +1. The time now is 10:28 AM.