Challenge No. 91: Transpose the problem table into result table.
Solved using: Power Query (Table.AddColumn, Table.SelectRows).
LOOKUP
Finds a value in a one-row or one-column range in Excel.
Match Reverse Word Containment
Challenge No. 264: Ananyms are words in reverse.
Solved using: Power Query.
Find Previous Prime Digit Number
Challenge No. 261: Single digit prime numbers are 2, 3, 5 & 7.
Solved using: Excel VBA.
Custom Grouping! Part 10
Challenge No. 153: The table includes two columns, From and To, where each row represents a range of dates.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Table.Group), Python, Python in Excel, and R.
Match Ages Using Email First
Challenge No. 78: Populate Age in Table 1 on the basis of Table 2.
Solved using: Power Query.
Fill Up And Down !
Challenge No. 141: For each blank cell, replace the null value with the value from the row above that has the same ID.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (Table.Group), Python, Python in Excel, and R.
Apply ATBASH Cipher Rules
Challenge No. 217: ATBASH Cipher
This is case sensitive problem.
Solved using: Excel VBA.
Vice Presidents Turned Presidents
Challenge No. 216: List the Vice Presidents who have been presidents also and list their vice-presidency and presidency years separated by comma.
Solved using: Power Query.
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).
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.