need to total occurances of Long distance Phone Number

[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.

 

[Frank Kabel]

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

 

[Jason Morin]

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