delete duplicate listings in excel/word

  shauny36 19:03 04 Apr 08

am trying to sort out my music list by there are lots and lots of duplicate lists.have got in excel and word.

eg: abba-best of
britney spears-variuos
britney spears-variuos
cool for cats-various
depache mode-greatest hits
depache mode-greatest hits
eminem-curtain falls

so any that are duplicated twice i want to delete
but have a very very large list and a lot of duplicates so dont want to type in the artist or song etc.

or is there another program i can use then copy it back into excel/word.

  shauny36 19:04 04 Apr 08

am using word/excel 2007

  VoG II 19:08 04 Apr 08

In Excel 2007 (only) select your cells, then on the Data tab click Remove Duplicates.

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Prehistoric Britain is laid out in these Royal Mail stamp illustrations

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…