Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Ive been racking my brain trying to figure this out on my own but can't seem
to get it right. The problem that I have is I am trying to match phone numbers in a column with a data base of the first 6 digits of the number that I can call, and either get a true or fasle or any thing that will indicate that I can call those numbers. Example: Number NPANXX Results 2813356789 281225 False 2813377896 281337 True 2815672345 281445 False 2813458765 False 2814452321 True The results shoud be (False,True,False,False,True) in column C because the number does not have the the first 6 digits |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Get External Data - not editable using Query Wizard | Excel Discussion (Misc queries) | |||
AHHH! Again | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |