identify Numbers in a list as Mobile,Landline,STD or ISD numbers

[lattu007]

i have a HUGE list of numbers including Mobile Numbers, Landline number
and that too of various states in India.
We need to identify and segregate the given Data(List) on the basis o
Mobile Number LandLine Numbers and ISD Numbers.

Provided :
-we have a saperate list of Mobile Number State n Service Provide
Identification Codes.
-a List of STD Codes of all the States in India
-a list of ISD Codes of all the countries

can i get a Formula to bifurcate/Identify the various numbers in th
given List .

 

[Spencer101]

i have a HUGE list of numbers including Mobile Numbers, Landline number
and that too of various states in India.
We need to identify and segregate the given Data(List) on the basis o
Mobile Number LandLine Numbers and ISD Numbers.

Provided :
-we have a saperate list of Mobile Number State n Service Provide
Identification Codes.
-a List of STD Codes of all the States in India
-a list of ISD Codes of all the countries

can i get a Formula to bifurcate/Identify the various numbers in th
given List ..

More than likely yes. perhaps you could provide some example data?

The problem I can see with this is the data is potentially sensitive s
you wont really want to post it here if it has names and numbers of rea
people