Hello,
I'd like a formula that returns true if ALL words within a cell (See A1 below) appear on another cell (B1), regardless of word order. Thanks in advance.
Cell A1: House Tree Cat
Cell B1: Bench Cat Pier Tree Door House
Update: see attachment below
Data_Workbook.xlsx
Bookmarks