How to delete duplicates in excel?

  dougle00 12:11 12 Sep 07
Locked

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

Thanks

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

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 07

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 07

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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac