Forum Discussion
VBA code for removing duplicates
jee007 Why bother learning VBA if you can do it with a few clicks and/or with standard Excel options.
Format the data range in "the other sheet" as a structured Excel table (Ctrl-T). Select a cell anywhere inside the table and you'll notice a Design ribbon at the top. Open it and look for the icon "Remove duplicates" and follow the instructions.
Alternatively, you could look into the UNIQUE function. It displays only the unique values from a range in what is called a dynamic array. Thus, effectively removing duplicates.
jee007 Why bother learning VBA if you can do it with a few clicks and/or with standard Excel options.
Format the data range in "the other sheet" as a structured Excel table (Ctrl-T). Select a cell anywhere inside the table and you'll notice a Design ribbon at the top. Open it and look for the icon "Remove duplicates" and follow the instructions.
Alternatively, you could look into the UNIQUE function. It displays only the unique values from a range in what is called a dynamic array. Thus, effectively removing duplicates.
- Thanks for the option. They just want to automatize the process, but I will look into that formula
