Hello everybody,

I have one big/small problem with extract the right numbers from a table which has 208589 rows. The internal parameters are these: we have numbers that has 6 places (xxxxxx) and is filed with the numbers from 1 to 9.

I want that the number has the difference 2 in one or more places. Example:

112647 ; these number is GOOD, because let say that we choose the starting point

112648 ; these number is NOT GOOD, because it has from the above number in last

place the degree 1 (8-7=1)

221658 ; these number is also NOT GOOD, because it has from the first number in

first and second place degree 1 (2-1=1) in third and fifth and sixth places it

has also degree 1

112667 ; these number is GOOD because it has in fifth place degree 2 (6-4=2)

212556 ; these number is NOT-GOOD, because if we than take the above number as

GOOD, than this one is not, because it has from the number above in

first, fourth, fifth and sixth places degree 1

Another example from a table:

Does somebody know how to solve this, because I am not good in mathemathics and programming so that I can write a macro that will do this calculation faster than me.

Thank you and have a nice day

## Comments rated to be "almost" Good Answers:

Re: How to Extract Numbers From a Table List" by StandardsGuy on 12/18/2011 12:45 PM (score 1)