Posted to microsoft.public.excel.programming

JAgger1

external usenet poster

Posts: 42

Removing Sequential Numbers

I've got 1000 data sets, I would like to remove the data sets that
have sequential numbers with in the set. Here's an example

A1: 1 2 5 7 9
A2: 1 3 5 7 9
A3: 1 3 4 5 8
A4: 3 4 6 7 9
A5: 2 4 6 8 0

How would I write a formula to remove any of the data sets (A1, A3,
A4) that have sequential numbers in it? Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Sequential Numbers	LiAD	Excel Discussion (Misc queries)	5	January 8th 09 03:39 PM
IF/THEN/ELSE for sequential numbers	juggler	Excel Programming	4	June 13th 07 04:52 AM
Sequential Numbers	abcdexcel	Excel Discussion (Misc queries)	3	January 18th 06 11:06 AM
sequential numbers	Harley	Excel Worksheet Functions	1	January 12th 06 09:57 PM
Sequential numbers	BEEJAY	Excel Programming	7	August 9th 05 07:14 PM

All times are GMT +1. The time now is 07:29 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us