Hi all. I have been an avid visitor of this site for awhile and thank u all for your help.

Here is my problem.

I have a set of phone numbers, about 6,000 of them, listed in a single column, sorted in descending order.
I would like to write a formula that looks through the column and extracts phone numbers where the last three digits are consecutive numbers.
ie 1300 360 601 and 1300 360 602.

Is this possible?

Thanks in advance for your advise.