Hi ladies and gents,
I have this task I am working on where I have a data set of around 58,00 rows and 21 columns.
My task is to count and delete any duplicate rows. The rows need to match the previous row in columns 1, 2, 3, 4, 5, 6 and 7.
I have looked around and have found lots of VBA codes which work great but only check over a single column.
I have also done it the COUNTIFS way which works but it a little messy for my liking.
I know there is a Remove Duplicates function in excel but I need it to output the total number of duplicates into a cell.
Also since its quiet a large macro, a status bar would also be great just to know where its up to.
Any help, idea or even a link to a thread that's relevant would be greatly appreciated.