Challenge No. 399: Extract the unique alphabets from the given strings and count their frequencies of occurrence.
Solved using: Python.
SORT
Sorts an array in ascending or descending order in Excel.
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.
Stack Matrix Diagonals Horizontally
Challenge No. 358: Stack both the diagonals of n x n metrices horizontally.
Solved using: Python in Excel.
Digits with Higher Frequency
Challenge No. 356: List the digits whose frequency is > frequency of the maximum digit
Ex.
Solved using: R.
List all Katadrome numbers
Challenge No. 344: List all Katadrome numbers.
Solved using: Python in Excel.
Sort odd positioned numbers
Challenge No. 341: Sort the numbers at odd positions.
Solved using: Python in Excel.
Create half-yearly sorted table from data
Challenge No. 340: From dataset in column A, create the table under Answer Expected.
Solved using: Python in Excel.
Find Min and Max for all zones
Challenge No. 332: Find the Max and Min for all Zones.
Solved using: Python in Excel.