Challenge No. 395: Coordinates for points are given in x, y format.
Solved using: DAX.
List.Transform
Applies a function to each element in a list in Power Query.
Digits With Sum Equal to Length
Challenge No. 390: Find the min, max and count of n digit numbers where n = sum of digits
Ex.
Solved using: Python in Excel.
Numbers With Larger Successors
Challenge No. 379: List all the numbers where all succeeding numbers are larger than the number.
Solved using: Python.
Split on First Greater Sum
Challenge No. 378: Split the numbers into two parts where sum of first part is > sum of second part where it happens for the first time.
Solved using: R.
Find Palindromes by One Deletion
Challenge No. 374: A Palindrome word is that which is same even read backwards.
Solved using: Python in Excel.
Monthly Per Diem Calculation
Challenge No. 149: The data is for business trip start and end dates of employees.
Solved using: Python.
Count Digits in Square Range
Challenge No. 373: Count the number of of Ds into square of numbers from N1 to N2 (both inclusive).
Solved using: Python.
Fill Down and Up by Customer
Challenge No. 147: Fill down / up all 4 columns for different customer IDs.
Solved using: Python.
Extract Longest Alphanumeric Segment
Challenge No. 361: Separate out the largest sequences of English alphabets and numbers from the given strings.
Solved using: Python in Excel.
Transpose People Table
Challenge No. 138: Transpose the problem table into result table.
Solved using: R.