I had two formulas for working with phone tolls. I moved offices a while back and can not find the disk I burned them to, and I cant remember them.

One of the formulas was like this: If the cell contains and or equals target number than put “incoming” (and/or if not than “outgoing”) in this (a different) cell.

I also had a formula that if the phone numbers came in 3 columns i.e. area code in one column, prefix in a second column and the last four digits in a third column, would combine all the numbers in one cell.

Thank you for your assistance

Howdy. Regarding the first, can you post a simple example?

Re: second question, you can use the concatenate symbol (&), if you want dashes

=A2&"-"&B2&"-"&C2

if no dashes needed, then

=A2&B2&C2
________
PLYMOUTH SUPERBIRD (http://www.dodge-wiki.com/wiki/Plymouth_Superbird)

Thank you. A sample of the first would be


If the target number 555-669-4569 is in the dialed number column then the call is lets say incoming, and the formula would display "INCOMING" in the direction column. If there is a different number from the target number in the dialed column then the formula would put "OUTGOING" in the direction column. I hope that makes more sense. Thank you for the help.

For some reason, when I click on the link to downlaod, I get a message stating that it is an invalid attachment link.
________
Ford Prodigy Specifications (http://www.ford-wiki.com/wiki/Ford_Prodigy)

I uploaded it again. Maybe it will work now.

Yes, I downloaded. Am looking at the file now.

I made a dynamic named range for column A, TargetNo

=OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A:$A)-1,1)

Then in C2, I put this formula and copied down:

=IF(ISNA(MATCH($B2,TargetNo,FALSE)),"incoming",B2)

This might get you started.
________
DIGITAL VAPORIZER (http://digitalvaporizers.info)

Thank you very much!:D