Get common words between lists using an Excel formula that combines an XLOOKUP and a TEXTSPLIT. Getting the common words ie easy, it's simply a lookup from one to the other and if found, then those words are common
Link to Excel file
https://docs.google.com/spreadsheets/...
Link to Excel challenge
https://www.linkedin.com/posts/excelb...