Home |
Search |
Today's Posts |
#1
|
|||
|
|||
comparing colum data and exporting
I have not been able to figure out how to do this. Ihope someone can help.
I have all call traffic in an excel file. Can i compare colum A's value with colum B's then export Colum c's data if the value is equal in A & B. I want to figure out how much we spend on calls between sites. Colum a contains the calling parties number whilst colum b contains dialed no. Colum c is the cost. Can anyone help?? Thanks Phil. :) |
#2
|
|||
|
|||
comparing colum data and exporting
If column A's value = column B's value, doesn't that mean that the calling
number and called number are the same? I don't quite see how that would happen, but.... I'd insert a new column (D?) and use a formula: In D2: =b2=c2 and drag down Then apply data|filter|autofilter to see the True's. phil wrote: I have not been able to figure out how to do this. Ihope someone can help. I have all call traffic in an excel file. Can i compare colum A's value with colum B's then export Colum c's data if the value is equal in A & B. I want to figure out how much we spend on calls between sites. Colum a contains the calling parties number whilst colum b contains dialed no. Colum c is the cost. Can anyone help?? Thanks Phil. :) -- Dave Peterson |
#3
|
|||
|
|||
comparing colum data and exporting
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. |
#4
|
|||
|
|||
comparing colum data and exporting
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
exporting a lot of data | Excel Worksheet Functions | |||
Exporting selected data / automation | New Users to Excel | |||
Exporting Data to Excel-Date Format Changed | Excel Discussion (Misc queries) | |||
exporting data | Excel Discussion (Misc queries) | |||
exporting data to a secondary spread sheet | Excel Worksheet Functions |