Removing Duplicates
Perhaps something like this:
With your list in Cells A3:D4000
and list headings in cells A3:D3 (Title, FName, Lname, Location)
F1: DupTest
F2: =COUNTIF(C$3:C4,C4)1
Select your list (A3:D4000)
DataFilterAdvanced Filter
List Range: (already selected)
Criteria Range: $F$1:$F$2
Click the [OK] button to filter the list in place.
That will hide the first occurrence of a LName and display only the
duplicates.
Select the visible cells below the column headings
Edit|Delete (you can only delete entire rows in a filtered list)
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"Danielle" wrote:
Hi
I am running v.2000 and need some help. I have an excel sheet containing
multiple columns and 1000s of rows.
I know how to delete rows which are completely identical (advanced filter
etc) but I need to know the following:
If there are two rows which are generally different (and so won't be deleted
by the advanced filter method), but each have an identical value in column D,
how would I get rid of the entire row containing the duplicate cell?
So for example if I had three rows as follows:
Mr | Joe | Bloggs | London
Mr | Tom | Jones | Glasgow
Mr | Ben | Jones | Essex
None of these would count as traditional duplicates via the advanced filter
method.
But what if I wanted to get rid of duplicate surnames - in the above example
I would ideally want to be left with just one of the "Jones" rows - how can I
do this?
It is worth noting that I have only basic experience with excel and so am
not familiar with macros etc - I tried one macro tutorial that didnt work :-S
Hope someone can help!
Thanks
Danielle
|