Hiya,
Not even sure if this is possible, Basically I have a spreadsheet with 48 columns, and over 30000 rows.
The rows of data do have duplicates in them but some of the duplicate rows have more information then the others. I want to get rid of the rows with the least information.
So basically is it possible to make a macro that finds duplicates and compares them, deleting the row with the least information?
I have included a small sample spreadsheet same heading etc but no real data (and only 5 rows). The column that it needs to check for similarities is "Q" named "REG NR"
Please let me know if this is possible and how I would go about doing something like this?
Thanks guys.