I found this and it works for what I need, but how do I get it to list through the entire Column A and how would I get it to output the results in column B or at the very least highlight all the matching results in column A?
https://stackoverflow.com/questions...ls-have-same-characters-in-any-order-in-excel
https://stackoverflow.com/questions...ls-have-same-characters-in-any-order-in-excel
Last edited by a moderator: