Excel BI Challenge Workout 040

Workouts Excel BI Challenge
1

— CAN YOU SOLVE THIS - EXCEL CHALLENGE 40 —
(Power Query solutions are also welcome for Excel Challenges)

Provide a formula to find common unique alphabets between 2 cells in the same row.
Hence for “deer” and “seer”, the answer would be “er”.

(Post answers in Comment. Your formula need not be different from others as long as you have worked out your formula independently)

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

#excel, #challenge, #advancedexcel, #excelchallenge, #excelproblem, #excelquestion, #excelsolution, #excelformulas, #excelfunctions, #exceltips, #exceltricks, #powerquerychallenge, #powerbichallenge, #powerqueryproblem, #M, #powerpivot

image
image1071×613 74.4 KB

Excel BI’s LinkedIn Post

2 
=LET(_s,
LAMBDA(x,MID(x,SEQUENCE(LEN(x)),1)),
MAP(A2:A10,B2:B10,
LAMBDA(a,b,
IFERROR(CONCAT(UNIQUE(FILTER(_s(a),
ISNUMBER(XMATCH(_s(a),_s(b))),""))),""))))

Common Characters - Quadri Atharu.xlsx (25.1 KB)