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.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Match Reverse Word Containment
Challenge No. 264: Ananyms are words in reverse.
Solved using: Power Query.
Insert Increasing Header Intervals
Challenge No. 90: Insert header row after 1 name, then after 2 names, then after 3 names and so on.
Solved using: Power Query.
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.
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.
Find Previous Prime Digit Number
Challenge No. 261: Single digit prime numbers are 2, 3, 5 & 7.
Solved using: Excel VBA.
Replace Repeated Letters
Challenge No. 259: If an alphabet appears more than once, replace is with “)” otherwise replace it with “(“.
Solved using: Excel VBA.
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.
Count of People by Age Group
Challenge No. 87: Generate the result table which has the count of different age groups.
Solved using: Python in Excel.
Decrypt Route Cipher
Challenge No. 258: Route Cipher Decryption – This time you would need to decrypt the given Encrypted text.
Solved using: Excel VBA.