— CAN YOU SOLVE THIS - EXCEL CHALLENGE 136 —
(Solutions in any language are also welcome for Excel Challenges)
Mask the string with asterisks if a word given in Words column appears in that row.
Number of asterisks will be same as the number of characters in the Words.
The word in String should appear distinctly, it should not be contained in another word. Hence, if string is “seashore” and replacement word is “sea”, the answer would not be “***shore” but “seashore” only.
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/dhGE6s4n
#excel, #excelchallenge, #powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #office365, #python, #r
Excel BI LinkedIn Post