Fortune Telling Collection - Comprehensive fortune-telling - Excel judges whether a cell contains characters in another cell, regardless of the order.

Excel judges whether a cell contains characters in another cell, regardless of the order.

What is the result after the verdict? How to express it? Can you press the picture below? What's in B 1? Not given in the question. Guess 1: "Many years"

c 1 = IF(COUNT(FIND(MID(b 1,ROW(INDIRECT(" 1:" & amp; Len (B 1)), 1), $ A $ 1)) = Len (B 1), "including" and "excluding")

At the same time, press Ctrl+Shift+Enter to enter the array formula and drop it down.