Identifying and totaling up duplicate cells in Excel
 

Hi can anyone help me??
I have two worksheet (1 & 2) with telephone numbers in column 'A'. What I
need to do is run a macro in sheet 2, that will identify the same numbers in
sheet 1 and total them up for me. Is this possible or is there a better way
of doing this?
--
Paul

Identifying and totaling up duplicate cells in Excel
 

sounds like you just need a countif

in sheet 2, cell B2..

=COUNTIF(Sheet1!A:A,A2)

Will give total # of times this phone number is on the other sheet.

Paste the formula to bottom.

"Paul" wrote:

Hi can anyone help me??
I have two worksheet (1 & 2) with telephone numbers in column 'A'. What I
need to do is run a macro in sheet 2, that will identify the same numbers in
sheet 1 and total them up for me. Is this possible or is there a better way
of doing this?
--
Paul

Identifying and totaling up duplicate cells in Excel
 

Hi Sean,
thanks very much for your prompt reply. I should have worded my query
better. What I was after was a macro or a method (as I'm a novis at this sort
of stuff) where after the pohone numbers have been highlighted in sheet one
the total of numbers highlighted is added up in a single cell i.e. if there
were 24000 numbers in sheet 1 and 3000 numbers in sheet 2, I want to run a
macro that highlights which of the 3000 numbers appear in sheet 1 and the
total of all the highlighted numbers e.g. out of 24000 numbers on sheet 1,
21700 from sheet 2 were identified.
--
Paul


"Sean Timmons" wrote:

sounds like you just need a countif

in sheet 2, cell B2..

=COUNTIF(Sheet1!A:A,A2)

Will give total # of times this phone number is on the other sheet.

Paste the formula to bottom.

"Paul" wrote:

Hi can anyone help me??
I have two worksheet (1 & 2) with telephone numbers in column 'A'. What I
need to do is run a macro in sheet 2, that will identify the same numbers in
sheet 1 and total them up for me. Is this possible or is there a better way
of doing this?
--
Paul