How to completely remove duplicate rows in vba
Hi,
In one sheet I have many duplicate rows and I wanted to remove
completely and left non duplicate rows.Pls help how to do in VBA.
Example:
Before
A B
Mary 50
Jane 20
Sam 10
Jery 30
Jane 20
Sam 10
After
A B
Mary 50
Jery 30
Left only non duplicate rows.
Pls help.Thanks
|