mldaigle1
asked on
Excel Macro to delete duplicate name / row
Hi,
I need your help in order to have a macro that will look into ColumnA find duplicate pc name and delete the row of the duplicate.
Can you assist?
I need your help in order to have a macro that will look into ColumnA find duplicate pc name and delete the row of the duplicate.
Can you assist?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Deadman, this is exactly what i wanted, the macro works just fine. I will be able to call that macro at the end of the other one for clean up purposes.
Have a good weekend,
:)
Have a good weekend,
:)
1) Select all of your list, including the header row
2) Click "Remove Duplicates" on the Data tab of the ribbon
3) Select/Deselect columns until only Column A is left
4) Click OK.