Challenge No. 208: Find those customers who have made at least one payment in all quarters in its range.
Solved using: Power Query.
Encrypt Using Date Cipher
Challenge No. 207: DATE CIPHER
Date cipher is a type of Caesar’s shift cipher where key is current date in YYYYMMDD format.
Solved using: Excel VBA.
Filter Values Based on Table
Challenge No. 61: Generate Result table on the basis of T1 and T2.
Solved using: Power Query (List.Distinct, Table.Group, Table.Pivot).
Square Root Contains Number
Challenge No. 206: Find the number after column A numbers whose square root contains the number itself.
Solved using: Excel VBA.
Top Net Salary Earner
Challenge No. 205: Table 1 has salary for different names and Table 2 has percentage deduction applicable for various salary ranges.
Solved using: Python in Excel.
List All Dudeney Numbers
Challenge No. 204: A Dudeney number is a positive integer that is a perfect cube such that the sum of its decimal digits is equal to the cube root of the number.
Solved using: Power Query (List.Transform).
Classify Items as Used or New
Challenge No. 60: Generate the Result table from Problem table.
Solved using: Power Query (Table.AddColumn, Table.Split, Table.SplitColumn).
Encrypt Using Baconian Cipher
Challenge No. 203: Baconian Cipher
(This problem is case insensitive)
A is 0, B is 1, C is 2.
Solved using: Power Query.
Column Splitting! Part 1
Challenge No. 136: Split the ID values where a character is repeated consecutively.
Solved using:Excel (CONCAT, DROP, IF), Google Sheets, Power Query (List.Transform, Text.Combine, Table.AddColumn), Python, Python in Excel, and R.
Highest Marks and Location
Challenge No. 202: List the names and subjects as well as cell address where the highest marks in the grid appear.
Solved using: Power Query.