Excel BI Challenge Workout 140

— CAN YOU SOLVE THIS - EXCEL CHALLENGE 140 —
(Solutions in any language are also welcome for Excel Challenges)

List the common letters between Word1 and Word2 and sort them alphabetically.
Ex. Word1 = “humility”, Word2 = “modesty”
Common letters are “m, t, y”

Post answers in Comment.

(Your formula need not be a single formula. You can write multiple formulas to arrive at a solution. Also your formula need not be different from others as long as you have worked out your formula independently)

Download Practice File - https://lnkd.in/d2gNzpEK

#excel, #excelchallenge, #powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #office365, #python, #r

Excel BI’s LinkedIn Post