Excel BI Challenge Workout 047

Workouts Excel BI Challenge
1

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

Palindromes are those words which are same even when read from backwards. For example, radar will be radar only even when read from backwards.

List those Palindromes which are the longest in A2:A10.

(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/dCYgUpet

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

image
image872×612 88.3 KB

Excel BI’s LinkedIn Post

2 
=LET(_ap,
TOCOL(MAP(A2:A10,LAMBDA(_w,
LET(_seq,SEQUENCE(LEN(_w)),
_split,MID(_w,_seq,1),
_r,CONCAT(INDEX(_split,SORT(_seq,,-1))),
FILTER(_w,_r=_w)))),2),
FILTER(_ap,LEN(_ap)=MAX(LEN(_ap))))

Short Description of Variables

Summary

- _w: Represents each element from the range A2:A10
- _ap: All palindromes. It Stores the transformed values from the range A2:A10 after filtering the palindromes.
- _seq: Generates a sequence of numbers from 1 to the length of the current element _w.
- _split: Stores the individual characters of the current element _w.
- _r: Stores the characters of _w(words) in reversed order.
- _ap: Stores the filtered values after comparing each element with its reversed version.

Palindrome Quadri Atharu.xlsx (24.9 KB)