— CAN YOU SOLVE THIS - EXCEL CHALLENGE 124 —
(Solutions in any language are also welcome for Excel Challenges)
List the Disarium numbers from column A.
A Disarium number is that number where sum of each digit raised to the power of its position in the number is equal to number itself.
Position follows index 1 method not index 0.
Hence in 265, position of 2 is 1 and position of 6 is 2 and position of 5 is 3.
Ex. 175 is a Disarium number.
1^1+7^2+5^3 = 1+49+125=175
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/d34BpxEp
#excel, #excelchallenge, #powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #office365, #python, #r
Excel BI’s LinkedIn Post