need to total occurances of Long distance Phone Number

  • Thread starter Thread starter Paul D
  • Start date Start date
P

Paul D

I have created a filter, and I need to determine if a call
was a long distance phone number, the column name is
ToPhoneNumber. If the phone number starts with a 1 and has
more than 5 digits its a long distance phone number. I
need to exclude 800 and 877 non toll calls in my
calculation.

Once I am able to perform the above, I will then be able
to calculate the duration of the long distance phone calls.
 
Hi
try using a helper column for filtering this. enter the following
formula (if col. A stores your phone numbers):
=IF(AND(LEN(A1)>5,LEFT(A1,1)="1"),"Long Distance","Not long distance")
and copy this down for all rows. After this use this column as filter
criteria
 
It would help to know the exact format of your phone
numbers, but you could try something like:

=AND(LEFT(A1)="1",LEN(A1)>5,ISERROR(FIND("800",LEFT
(A1,6))),ISERROR(FIND("877",LEFT(A1,6))))

which will return TRUE/FALSE (True = long distance).

HTH
Jason
Atlanta, GA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Phone number 3
Need to determine if a call is Long Distance 2
Adding a "1" to Phone Number field 6
Date/ Phone log 1
Buying a modern phone help needed. ;-) 14
Faxing with a phone card 1
adding 1 before phone number 2
Long Distance? 2

Back
Top