Challenge No. 374: A Palindrome word is that which is same even read backwards.
Solved using: Python in Excel.
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.
Fruit Pair Frequency Grid
Challenge No. 148: Generate the grid shown where count need to be populated at intersections of rows and columns.
Solved using: Python.
Draw Inverted Triangle Shape
Challenge No. 372: Draw inverted right angled triangles as shown for an r value.
Solved using: Python.
Filter Products by Date Range
Challenge No. 371: This problem is contributed by Mehmet Çiçek
Find the list of products (alphabetically sorted) for the date range given in columns H & I from the table given in columns A to F.
Solved using: DAX.
Fill Down and Up by Customer
Challenge No. 147: Fill down / up all 4 columns for different customer IDs.
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.
Boundary Rows per Threshold
Challenge No. 146: For a group –
List the last row where value < Threshold
and also list the first row where value > Threshold
If more than one row meets the criterion, then capture all those rows.
Solved using: Python in Excel.
Encrypt Text with Multi-Tap Cipher
Challenge No. 368: Encrypt the given words using Multi Tap Cipher.
Solved using: Python.