Removing Both Duplicates from a list
Hi Don -
This is EXACTLY what I need - but please forgive the noob question: where
exactly do I enter this equation?
Thanks,
JD
"Don Guillett" wrote:
try this idea. Works for TWO dups as you posted
Sub removeALLdups()
mc = "a"
For i = Cells(Rows.Count, mc).End(xlUp).Row To 2 Step -1
If Cells(i - 1, mc) = Cells(i, mc) Then Rows(i - 1 & ":" & i).Delete
Next i
End Sub
--
Don Guillett
Microsoft MVP Excel
|