Pete,
Me again. As I'm sitting here thinking about this and playing with the
numbers and formula it's all making more sense. when you say unique list on
separate sheet if I was to take all the numbers for the 3 months and put
them in one column on a different sheet is there a way I can tell it to only
list the number once? to remove all duplicates for my unique list?
Thanks again so much.
"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