Challenge No. 91: Transpose the problem table into result table.
Solved using: Power Query (Table.AddColumn, Table.SelectRows).
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Check Digit Occurrence Validity
Challenge No. 266: List those numbers only where odd digits appear odd number of times and even digits appear even number of times.
Solved using: Excel VBA.
Odd Even Min Max Split
Challenge No. 263: Separate out odd and even numbers and give their min and max separated by dash.
Solved using: SQL.
Eight Knights Puzzle!
Challenge No. 160: The problem aims to place 8 knights (hours) on a chess board in such a way that each row/column is occupied by a single knight and no knight removes the other one from the chess board.
Solved using:Excel, Power Query, Python, Python in Excel, and R.
Find Previous Prime Digit Number
Challenge No. 261: Single digit prime numbers are 2, 3, 5 & 7.
Solved using: Excel VBA.
Generate Sequential Number Grid
Challenge No. 260: Generate the grid as per number given in cell A1.
Solved using: Excel VBA.
Add Hierarchical Location Indexes
Challenge No. 88: Add the indexes for Country, State and City.
Solved using: Python in Excel.
Replace Repeated Letters
Challenge No. 259: If an alphabet appears more than once, replace is with “)” otherwise replace it with “(“.
Solved using: Excel VBA.
List Repeated Column Words
Challenge No. 257: List those words which get repeated in a column.
Solved using: Python in Excel.
Extract Vowels with Positions
Challenge No. 256: Extract the vowels and their positions within the string.
Solved using: Excel VBA.