If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|