# Excel BI Challenge Workout 047

— 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)

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

``````=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.