I think I have this working for me. But not quite exact. I need to know how
to change the ranges for it to calculate more for me. I would like to tell
me how many times that certain number was called on 2 separate months. I
think I can figure this out with a little more explanation. When I did it
for the second column it also included what was in column a. So for example
there was 6 in column A and 4 in column B it gave me a total of 10. I would
like it to 6 and 4. I'm getting closer!!! Thank you!!!!!

"Pete_UK" wrote:


Debra Dalgleish shows how you can compile a unique list of phone numbers
using Advanced Filter he

'Excel Filters -- Advanced Filter'
(http://www.contextures.com/xladvfilter01.html)

It is better to put your unique list in column A of a separate sheet,
then in column B (B2) you can have a formula like this:

=COUNTIF(Sheet1!A:A,A2)

assuming your phone numbers are in column A of the first sheet. Just
copy this down to get a count for each of the phone numbers dialled.

Hope this helps.

Pete

wookie;289279 Wrote:
I have 3 months of phone numbers from phone bills and I need to know
if
there is a way I can make a formula to show me the duplicate numbers
from
month to month. I have input them in 3 columns and not sure what to do
from
here. I've been reading on the forum and some of I'm reading is not
making
sense. I know how to use the basics of excel but now getting this in
depth
I'm not sure what to do.


--
Pete_UK
------------------------------------------------------------------------
Pete_UK's Profile: http://www.thecodecage.com/forumz/member.php?userid=205
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=80845