Challenge No. 380: Draw an N x N square where sides and diagonals are filled with x.
Solved using: Python.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
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.
Fill Missing Time Fields
Challenge No. 150: You need to fill in the blanks.
Solved using: Python.
Convert Marks to Grade Points
Challenge No. 375: Calculate the grade points for given marks.
Solved using: Python in Excel.
Find Palindromes by One Deletion
Challenge No. 374: A Palindrome word is that which is same even read backwards.
Solved using: Python in Excel.
Draw Inverted Triangle Shape
Challenge No. 372: Draw inverted right angled triangles as shown for an r value.
Solved using: Python.
List Cyclops Palindromic Numbers
Challenge No. 370: A Cyclops number is a number that has a zero in the center (so, it needs to have odd number of digits).
Solved using: Python.
Perform Faro Shuffle Types
Challenge No. 369: Faro Shuffle – Divide the data in two equal parts (data will always be even, so two equal parts).
Solved using: DAX.
Find Word by Exact Index
Challenge No. 367: Capture the word starting at given index.
Solved using: Python.
Uppercase Letters Around Numbers
Challenge No. 362: Convert the English letters around a number to upper case.
Solved using: Python in Excel.