What i need to be able to do is compare any of the numbers in colum a 'from
phone line no. **********' to all of the numbers in colum b ' dialed numbers
*********'. if any of the colum a numbers i.e. all of my phone lines no's are
in colum b, this would indicate an intersite call. i can then look at the
cost in colum c and add all that are equal to the colum a/b scenario
together. Does this make more sense?

"Dave O" wrote:

If A is the calling party and B is the receiving party, but you need
site-to-site rather than party-to-party data, is there any commonality
between numbers that you could use to derive site information? (Please
excuse me while I lapse into a USA-centric example, it's the only one I
know.) Telephone numbers are in the format
NPA-NXX-#### where NPA is the area code, NXX is the exchange, and ####
is the number. In this example, you could sum the cost of dialed calls
or received calls by NPA-NXX, which would equate to site-by-site.

Is there some similar commonality you could use to designate a
particular site? If you go the number-to-number route, you'd just have
to develop another scheme to aggregate costs by site.