I have a speadsheet with about 800 rows of data. Each row starts with a five-figure number.Some rows have been accidentally duplicated when the sheet was compiled (about 10% of them and they are spread throughout the sheet).Is there a way to get Excel to find these 'double entries' and delete them or do I need to do it manually?Thanks in advanceJohn
Does this help? click here
I'll have a look at your link.
That's done the trick and saved a great deal of time!Thanks againJohn
You are welcome :o)
This thread is now locked and can not be replied to.
OnePlus 5 review
Alice Saey's mesmerising animation for Dutch singer Mark Lotterman
iPad Pro 10.5in (2017) review
Comment faire une capture d’écran sur un Mac ?
© Copyright 2017 IDG UK. All Rights Reserved.