Counting Consecutive Numbers in a List
 

Is there a function in Excel that will count how many sets of 2 or 3
consecutive numbers appear in a list of 20 numbers?

Sorry if this post is redundant, but I cannot see it go through...

Thanks,

Steve

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
...
Is there a function in Excel that will count how many sets of 2 or 3
consecutive numbers appear in a list of 20 numbers?

Sorry if this post is redundant, but I cannot see it go through...

Thanks,

Steve