My friend is a DJ and has asked me to help him organize his music library.

Everything was going fine until he mentioned that he wanted to sort the songs into as little 'genre' categories as possible, and I stumbled on the fact that he had accidentally repeated the same combinations of genres in different orders, for example he has 241 songs listed as 'Pop/Club' and 33 listed as 'Club/Pop'.

As I found the above example by chance, my query is: how can I use Excel to detect these duplicates? My initial thought is that this is essentially an anagram solver, which is not something I have experience with and I'm not aware of a function that directs Excel to look for the exact same characters/letters in, potentially, a different order.

New contributor
Jake is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • you could achieve this by creating a reference table, you will need to list every available genre, and then the genre it should actually be, then perform a look up to this table. Other wise Excel has literally no way of knowing pop/club should actually be club/pop – PeterH Jun 30 at 12:54
  • Hi Jake, not sure why this has been closed - it seems simple enough. Are all of the combinations you are looking for using the / as a seperator? How many types of music appear in a single combination - eg. can you have 3 or four or is two types the max? – Justin Doward Jun 30 at 14:02
  • Hi Justin thanks for the question - a lot of songs initially had 3 (or sometimes even 4) genres tagged, I've gone through and shortened everything so the maximum in a single combination is 2 – Jake Jun 30 at 22:53