Challenge No. 78: Populate Age in Table 1 on the basis of Table 2.
Solved using: Power Query.
Prime Difference Category
Challenge No. 242: If Number1 and Number2 are primes and if difference between them is:
2 – Twin Prime
4 – Cousin Prime
6 – Sixy Prime
Categorize the Numbers given in column A and B.
Solved using: Power Query (List.Transform).
Alternate Letter Casing
Challenge No. 241: Convert the English letters into small and capital alternately.
Solved using: Excel VBA.
Extract From Text! Part 3
Challenge No. 149: Extract texts between and pair of the bellow characters.
Solved using:Excel (LAMBDA, LET, MAP), Google Sheets, Power Query (Table.AddColumn), Python, Python in Excel, and R.
Sum Values by Letter Codes
Challenge No. 77: Generate the result table from problem table.
Solved using: Python in Excel.
Rotate Rows and Columns
Challenge No. 240: Now rotation has to be done for both columns and rows.
Solved using: Power Query.
Sorted Vowel Substitution
Challenge No. 239: Replace the vowels with vowels in sorted order.
Solved using: Excel VBA.
Filter Dates!
Challenge No. 148: For each customer, filter their first, last, and middle transactions from the provided “transactions” table.
Solved using:Excel (CHOOSEROWS, DROP, FILTER), Google Sheets, Power Query (Table.Combine, Table.Group), Python, Python in Excel, and R.
Create Simple Result Table
Challenge No. 76: Generate the result table from problem table.
Solved using: Power Query.
Count Stepping Numbers
Challenge No. 238: Stepping Number is that number where adjacent digits have the difference of 1 or -1.
Solved using: Python in Excel.