Hi. There is this stuff I do everyday with ms excel that contains a whole lot of data in it. And most of the time I search for records that appear twice on the sheet. but before I do that, I'll have to sort a particular column, say D, so as to get those records that appear twice together (one above the other). Someone gave me an idea of using macros for it, but I dont know how to write macros.
Please I need someone to tell me or show me how to go about it, i'LL REALLY REALLY BE GRATEFUL BECAUSE THIS IS SOMETHING I NEED URGENTLY. THANKS IN ADVANCE.
Kecy
6
Newbie Poster
Recommended Answers
Jump to PostThis macro does not require you to sort the list.
http:\\www.geocities.com\excelmarksway\excel\
DeleteDuplicates.xlsA toolbar button should appear on the worksheet. The Listviewer button show a dialog that allows you to …
All 3 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.