Challenge No. 268: Find the Decrypted words corresponding to Encrypted words .
Solved using: Excel VBA.
By Topic
Challenges categorized by topic.
Extract From Text! Part 5
Challenge No. 162: Separate the values inside the curly braces { }, do the same for nested curly braces.
Solved using:Excel (IFNA, LAMBDA, LET), Google Sheets, Power Query (List.Transform, Table.AddColumn), Python, Python in Excel, R, and VBA.
Mark Repeats in Date Column
Challenge No. 91: Transpose the problem table into result table.
Solved using: Power Query (Table.AddColumn, Table.SelectRows).
Find Isogram Calendar Dates
Challenge No. 265: An Isogram date is a two digits year date in which no digit occurs more than once.
Solved using: Power Query.
Custom Grouping! Part 11
Challenge No. 161: Extract the list of dates associated with each product and display them under each other in separate columns.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (Table.Group), Python, Python in Excel, and R.
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.
List Dates Matching Product Rule
Challenge No. 262: List the dates in YYYY-MM-DD format from 21st century i.
Solved using: Python in Excel.
Add Hierarchical Location Indexes
Challenge No. 88: Add the indexes for Country, State and City.
Solved using: Python in Excel.
Filter Last Transaction!
Challenge No. 158: From the question table, extract the last transaction per product for each month.
Solved using:Excel (DROP, FILTER, GROUPBY), Google Sheets, Power Query (Date.Month, Table.AddColumn, Table.Combine), Python, Python in Excel, and R.
Decrypt Route Cipher
Challenge No. 258: Route Cipher Decryption – This time you would need to decrypt the given Encrypted text.
Solved using: Excel VBA.