Posted to microsoft.public.excel.misc
|
|
Removing Both Duplicates from a list
Use a Pivot table. This would show only 1 row with a count of how many dups
there are
"Don Guillett" wrote:
Try this For ALL , IF sorted
Sub removealldupsAll()
mc = "a"
lr = Cells(Rows.Count, mc).End(xlUp).Row
Set mrng = Range(Cells(2, mc), Cells(lr, mc))
For i = Cells(Rows.Count, mc).End(xlUp).Row To 2 Step -1
Count = Application.CountIf(mrng, Cells(i, mc))
If Count 1 Then Rows(i - Count + 1 & ":" & i).Delete
Next i
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"tim" wrote in message
...
I have a list that i need to remove all Duplicates, if I find any,
example
List
1
1
2
3
3
4
5
5
Goal
2
4
Not sure how to do this, I'm on office 2007 and I dont see a way to do
this
with Remove Duplicates as it still leaves me with one of each number.
|