Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Duplicate entries
I have a column with many numbers that are duplicates. How can excel help
me get rid of the duplicates with out doing each individual line one at a time? |
#2
|
|||
|
|||
One way ..
Assume the numbers are in col A, in A2 down Put in B2: =IF(COUNTIF($A$2:A2,A2)1,"X","") Copy B2 down This'll flag all duplicates in col A with an "X" Now do a Data Filter Autofilter on col B (put a label in B1 first) In the droplist in B1, select "X" This filters out all the duplicate rows Select the row headers for the duplicates (this will be all the "blue" colored filtered row headers) Right-click Delete Row Remove the Autofilter -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Keggarboy" wrote in message ... I have a column with many numbers that are duplicates. How can excel help me get rid of the duplicates with out doing each individual line one at a time? |
#3
|
|||
|
|||
Max wrote:
One way .. Assume the numbers are in col A, in A2 down Put in B2: =IF(COUNTIF($A$2:A2,A2)1,"X","") Copy B2 down This'll flag all duplicates in col A with an "X" Now do a Data Filter Autofilter on col B (put a label in B1 first) In the droplist in B1, select "X" This filters out all the duplicate rows Select the row headers for the duplicates (this will be all the "blue" colored filtered row headers) Right-click Delete Row Remove the Autofilter -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Keggarboy" wrote in message ... I have a column with many numbers that are duplicates. How can excel help me get rid of the duplicates with out doing each individual line one at a time? I also need help with this but when I do as you answered I get the message "Wrong in formula" and :A2,A2 is highlighted in the formula. I use a swedish localized Excel 2003 where the formulas use swedish names but english should work as well right? |
#4
|
|||
|
|||
No, you would need to use
=OM(ANTAL.OM($A$2:A2;A2)1;"X";"") it will translate English formulas if you get a workbook with them but you can't enter English formulas -- Regards, Peo Sjoblom "Christopher" wrote in message ... Max wrote: One way .. Assume the numbers are in col A, in A2 down Put in B2: =IF(COUNTIF($A$2:A2,A2)1,"X","") Copy B2 down This'll flag all duplicates in col A with an "X" Now do a Data Filter Autofilter on col B (put a label in B1 first) In the droplist in B1, select "X" This filters out all the duplicate rows Select the row headers for the duplicates (this will be all the "blue" colored filtered row headers) Right-click Delete Row Remove the Autofilter -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Keggarboy" wrote in message ... I have a column with many numbers that are duplicates. How can excel help me get rid of the duplicates with out doing each individual line one at a time? I also need help with this but when I do as you answered I get the message "Wrong in formula" and :A2,A2 is highlighted in the formula. I use a swedish localized Excel 2003 where the formulas use swedish names but english should work as well right? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Preventing Duplicate Entries within a column | Excel Discussion (Misc queries) | |||
I want to delete rows with duplicate entries within one column. | Excel Discussion (Misc queries) | |||
Duplicate entries | Excel Worksheet Functions | |||
Multiple Files, Duplicate Entries | Excel Discussion (Misc queries) | |||
Add numbers for duplicate entries then delete | Excel Worksheet Functions |