Alright, I have another. The problem this time is I want excel to
recognize a pattern. If I have a list of 8 numbers, I want to know if
there is ever 5 consecutive numbers.


2
5
4
10
8
6
3
4

I want it to recognize that there is a string of 5 (2,3,4,5,6)


--
DArinello
------------------------------------------------------------------------
DArinello's Profile: http://www.excelforum.com/member.php...o&userid=25589
View this thread: http://www.excelforum.com/showthread...hreadid=390090