Forum home » Delegate support and help forum » Microsoft Excel Training and help » Deleting Duplicates

Deleting Duplicates

ResolvedVersion 2016

Wed 5 Feb 2020, 17:10 Delegate Joanne said...

Joanne has attended:
Excel Introduction course

Deleting Duplicates

When trying to delete around 300,000 duplicate cells (which definitely include duplicates) I am getting the message 'No duplicates found' do you know why this would be happening? is it due to volume? Thanks

Wed 5 Feb 2020, 17:49 Trainer Jens said...

RE: Deleting Duplicates

Hi Joanne,

Thank you for the forum question.

It is not the number of duplicates which are the problem. I just tested removing 700.000 duplicates.

Do you compare all the columns or is it based on a part of the columns?

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Using the Quick Access Toolbar in Excel2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Excel hints and tips

Deleting Duplicates

Deleting Duplicates

RE: Deleting Duplicates

Excel articles

Excel tip:

Using the Quick Access Toolbar in Excel2010