Challenge No. 171: A string can be made by repetitions of substrings.
Solved using: Excel VBA.
LAMBDA
Creates custom reusable functions in Excel.
Reverse Prime Numbers
Challenge No. 170: Given is a list of prime numbers.
Solved using: Python in Excel.
Pad In The Middle!
Challenge No. 125: For the IDs in the table, insert zeros between the text and numbers to ensure that each ID has exactly 6 characters.
Solved using:Excel (CONCAT, ISNUMBER, LAMBDA), Google Sheets, Power Query (Text.Repeat, Table.AddColumn), Python, Python in Excel, and R.
Determine Cumulative Sum Based on Rules
Challenge No. 49: Generate the output table shown.
Solved using: SQL.
Sort Cities by Populated
Challenge No. 169: Order the cities columns on the basis of number of cells populated in descending order.
Solved using: Python.
Uppercase Position Finder
Challenge No. 168: Find the positions of uppercase letters and separate them by dashes.
Solved using: Excel VBA.
Find Missing Tuple Number
Challenge No. 167: Pythagorean tuples are those numbers which follow the rule a^2+b^2=c^2 where a, b and c are whole numbers.
Solved using: Python in Excel.
Merge! Part 2
Challenge No. 124: In Question Table 1, dates and prices for a product are provided.
Solved using:Excel (INDEX, LAMBDA, LET), Google Sheets, Power Query (Table.AddColumn), Python, Python in Excel, and R.
Porta Cipher Grid Formula
Challenge No. 166: The grid shown is used in Porta Cipher for Cryptography.
Solved using: Python in Excel.
Top Initials of First Ladies
Challenge No. 165: List the First Ladies’ names which start with Top 3 most frequently occurring letters.
Solved using: Power Query.