Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identifying duplicate entries | Excel Discussion (Misc queries) | |||
Identifying duplicate rows | Excel Discussion (Misc queries) | |||
Totaling columns in a row with duplicate data - Pivot Table?? | Excel Worksheet Functions | |||
IF= Cells not totaling | Excel Worksheet Functions | |||
Dame: identifying duplicate numbers within a column | Excel Worksheet Functions |