identify Numbers in a list as Mobile,Landline,STD or ISD numbers
i have a HUGE list of numbers including Mobile Numbers, Landline numbers and that too of various states in India.
We need to identify and segregate the given Data(List) on the basis of Mobile Number LandLine Numbers and ISD Numbers. Provided : -we have a saperate list of Mobile Number State n Service Provider 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 the given List .. |
Quote:
The problem I can see with this is the data is potentially sensitive so you wont really want to post it here if it has names and numbers of real people. |
All times are GMT +1. The time now is 04:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com