Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing duplicate rows from access?
I need to know how to remove duplicate rows from access or excel when only
one column has duplicates.. I don't care about the other field, I just need to keep the first one it finds. \ thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing duplicate rows from access?
One way ..
Assume duplicates to be checked on col A's data, where data is in row2 down In say, E2: =IF(A2="","",IF(COUNTIF(A$2:A2,A2)1,"x","")) Copy down to last row of data in col A. This flags duplicates with "x". Then apply autofilter on col E, choose: x Select the filtered rows (select the blue row headers) Right click Delete Rows Done! -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "mcpa" wrote: I need to know how to remove duplicate rows from access or excel when only one column has duplicates.. I don't care about the other field, I just need to keep the first one it finds. \ thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing duplicate rows from access?
In Access, you can use a Find Duplicates query. In Excel, Chip Pearson has a bunch of stuff
about them at www.cpearson.com -- Regards from Virginia Beach, Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "mcpa" wrote in message ... I need to know how to remove duplicate rows from access or excel when only one column has duplicates.. I don't care about the other field, I just need to keep the first one it finds. \ thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing duplicate rows from access?
In Excel.........Select the column and DataFilterAdvanced Filter.
Check "Unique Records" and Copy to another location". Gord Dibben MS Excel MVP On Mon, 28 Apr 2008 15:55:00 -0700, mcpa wrote: I need to know how to remove duplicate rows from access or excel when only one column has duplicates.. I don't care about the other field, I just need to keep the first one it finds. \ thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing duplicate rows | New Users to Excel | |||
Removing duplicate rows | Excel Discussion (Misc queries) | |||
removing duplicate rows | Excel Discussion (Misc queries) | |||
removing duplicate rows | Excel Discussion (Misc queries) | |||
Removing Duplicate Rows | Excel Discussion (Misc queries) |