Prev Previous Post   Next Post Next
  #1   Report Post  
DArinello
 
Posts: n/a
Default patterns


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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I do conditional formatting on number formats not patterns. dave55 Excel Discussion (Misc queries) 2 March 22nd 05 02:21 AM
can I customize cell fill patterns in Excel? bghough Excel Discussion (Misc queries) 0 March 10th 05 06:09 PM
Printing Patterns in Cells Noble1 Excel Discussion (Misc queries) 0 February 27th 05 11:53 PM
Excel cell patterns gisconsultant Excel Discussion (Misc queries) 0 February 21st 05 10:31 AM
Copying spreadsheet with fonts and patterns RTP Excel Discussion (Misc queries) 3 December 9th 04 11:49 PM


All times are GMT +1. The time now is 07:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"