Does anyone know of any functionality in Excel to easily identify and remove duplicated lines in a data table?
I have a buggy reporting system which we are due to replace but in the meantime I am stuck with it as the development is focused on the new system. It produces reports with rows which are duplicates of other rows, so I need to get rid of these before I can use it to produce useful information.
Thanks
Simon
Bookmarks