How to delete duplicates in excel?

  dougle00 12:11 12 Sep 2007
Locked

Anyone know how to automatically delete duplicates from 2 lists in excel?

Thanks

  VoG II 12:37 12 Sep 2007
  dougle00 12:55 12 Sep 2007

Thanks a million VoG I'll give that a go. Oh just a quick one, where do I input the program? Is there a macro button in excel?

Thanks

  VoG II 13:02 12 Sep 2007

click here

or in Excel press ALT + F11 to open the Visual Basic Editor then Insert > Module. You should now be looking at a white 'sheet' on the right hand side of the window. Copy the code and paste it there. Then close the VBE, Tools > Macro > Macros, highlight the name of the macro you want to run and click the Run button.

A note of caution - macros have no Undo (unless specially written) so you should try this on a copy of your workbook.

  silverous 13:37 12 Sep 2007

Alternatively you could just create one big list of the two and use the advanced filter option to list unique items only.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment regarder des séries et talk-shows américains en France ?