— CAN YOU SOLVE THIS - EXCEL CHALLENGE 143 —
(Solutions in any language are also welcome for Excel Challenges)
List the numbers which are Harshad number (also known as Niven number or Multidigital number). A Harshad number is that number which is divisible by the sum of its digits
Example: 1729 is a Harshad number as 1+7+2+9 = 19 and 1729 is divisible by 19 as remainder is 0 when 1729 is divided by 19.
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/d_HW-wRz
#excel, #excelchallenge, #powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #office365, #python, #r
Excel BI’s LinkedIn Post