Hello,

This is something i can't quite figure out how to do. I work in Telecom marketing, and one of the issues we have to deal with is sorting out numbers into categories, for example 50010000 is a golden category while 50018459 is normal , each will sell for a different price. now i have a range of numbers ( from 911-0000 to 911-9999 )and i want to identify the numbers that are golden category according to these rules:

1- Numbers four Identical Numbers example 911-1122
2- Numbers end with four Identical Numbers example 911-2222
3- Numbers with four sequence Numbers example 911-4567
4- Numbers with three sequence Numbers example 911-0567
5- group of Two similar numbers example 911- 2323


so all numbers should be in one column and the golden ones in another

hope you can help in this