If your numbers are one to a cell, in column A, you could drop this formula
in B5 and autofill through column B:
=IF(AND(A5=A4+1,A5=A3+2,A5=A2+3,A5=A1+4),"Run","")

"DArinello" wrote:


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