On Jan 6, 8:22*am, JAgger1 wrote:
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

You are not giving much to go on. Are you looking for a spreadsheet
formula or a macro? In either case - how is your data stored in the
spreadsheet? Are there always exactly 5 numbers? Are these numbers
stored in different cells? Etc.

For example - if there are always 5 numbers and they are stored in
columns A through E (with different data sets in different rows), then
you could somewhat easily write a spreadsheet formula to be placed in
column F which evaluates to zero if and only if the data set contains
sequential numbers, after which you could filter based on the values
in column F. But if the data sets are stored in strings which have a
label as a prefix (e.g. "A5: 2 4 6 8 0") then some preliminary parsing
of the data would be needed.