For this, the 2nd in the series of Advanced Formula Challenges, readers are asked to come up with a solution to the following:
Given two lists of names in B1:B10 and E1:E10 (as above), a formula is to be entered into A1, such that, when copied down to A10, returns TRUE if, for the corresponding name in column B, there exists at least one name in the range E1:E10 which is an anagram of that name.
Solutions should work not just for the data present here, but given any names of between 3 and 10 characters in the two ranges. It can be assumed that no cell in either of these ranges is empty.
Best of luck! Solutions next Sunday.