How to create/record and run macro for finding duplicates in excel
Macro represents a set of instructions which can be executed in a single command/trigger to perform specified actions. These are used to automate the repetitive tasks with in Microsoft office products like excel etc. Microsoft word and excel provide a mechanism to record the steps performed and then link it to some triggering mechanism like button etc so that all of the recorded steps could be executed again just on a single trigger like click of button. Today we will do the step by step demonstration of recording the macro to be used for finding the duplicate & corresponding number of occurrences and running the macro just on a single click. The sample excel initially had only one column having names and at the end of the exercise we had created a macro and a button for trigger. On the click of button, macro populates the duplicate names and corresponding count in second sheet. The sample excel with macro created as a part of this exercise can be accessed from here . In ...