how to use excel to track phone numbers
 

hello! i am sandy and i have not used excel for years and have forgotten most
of what i learned. what i need to learn is how to set up a page or ? on how
to track how many times a phone number appears. i would like to list the
date of the number also and sometimes the time. i know how to enter the
data, but i don't know how to get it to "match or put on one report" all the
numbers that are equal to 111 for example. i would like to say this is for a
business, but it is not. my husband has been getting different phone calls
(another woman maybee) and i would like to see how often he calls or the same
number is called. I get the info from his cell phone (time and date) i
would like to place it on something easier to "match" or identify same
numbers. thank you to all who take the time to respond!

how to use excel to track phone numbers
 

Hi Sandy,
Check out CountIF and SUMPRODUCT at John Walkenbach's site
http://www.j-walk.com/ss/excel/tips/tip52.htm
http://www.j-walk.com/ss/excel/eee/eee018.txt

and at Data Pig (some video tutorials)
http://www.datapigtechnologies.com/ExcelMain.htm

SUMPRODUCT Worksheet Formula Examples, Ken Wright, 2003-01-04.
http://google.com/groups?threadm=epm...40TK2MSFTNGP12

and of course your Excel HELP.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"honey42" wrote in message ...
hello! i am sandy and i have not used excel for years and have forgotten most
of what i learned. what i need to learn is how to set up a page or ? on how
to track how many times a phone number appears. i would like to list the
date of the number also and sometimes the time. i know how to enter the
data, but i don't know how to get it to "match or put on one report" all the
numbers that are equal to 111 for example. i would like to say this is for a
business, but it is not. my husband has been getting different phone calls
(another woman maybee) and i would like to see how often he calls or the same
number is called. I get the info from his cell phone (time and date) i
would like to place it on something easier to "match" or identify same
numbers. thank you to all who take the time to respond!

how to use excel to track phone numbers
 

This would be a snap to do with a very simple pivot table.

If all you have is one column of phone numbers with a heading such as
"numbers":

Select the whole column by clicking on the column letter at the very
top.

Click Data Pivot Table

Click Finish.

A new sheet will be created with a blank pivot table and a toolbar
containing the column heading, in my example "numbers"

Drag the column heading from the toolbar over to the area marked Drop
Row Fields Here

Drag the column heading from the toolbar one more time - this time to
the area marked Drop data items here.

The table should now appear as follows:

Count of number
number____________Total

123-4567___________12
345-6789____________4


Grand Total___________16


If, instead of "Count of number", the top heading reads "Sum of
Number",
Right click on Sum of Number, Click Field Settings, and choose "Count"

Good luck!


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=528395