Hi
Please find attached a workbook of sample data and the results im trying to achieve.
What I would like is a macro to run rather than currently sorting and deleting manually.
On the "data" worksheet is the raw data once pasted form another application and I have applied “text to columns” next what I normally do is remove duplicates based on column E then sort based on column J and F then manually remove all non duplicates.
There must be a duplicate in both J and F, all other data can be deleted.
If this could be put into a simple macro it would be fantastic as my data is many 1000’s of rows.
Thanks
David
Bookmarks