Challenge No. 47: Count the process groups as given.
Solved using: Power Query.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Symbol Replace by Frequency
Challenge No. 163: If an alphabet appears once in a word, replace it with a “?”.
Solved using: Power Query (Table.AddColumn).
Vernam Cipher Encrypt
Challenge No. 162: Vernam Cipher (also known as One time pad cipher)
1.
Solved using: Power Query (List.ReplaceMatchingItems, List.Transform, List.Zip).
Reverse Long Words
Challenge No. 161: If a word in sentence has length > Number, then reverse that word.
Solved using: Power Query (Text.Combine).
Table Transformation! Part 11
Challenge No. 122: Transform the question table into the reult table format.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Transform, Text.Contains, Table.AddColumn), Python, Python in Excel, and R.
Alphabet Prime Mapping
Challenge No. 160: Generate first 26 prime numbers starting with 2 till 101 (101 is 26th prime number).
Solved using: Python in Excel.
Reverse Cities Columns
Challenge No. 159: Reverse all columns from Cities1 to Cities5.
Solved using: Power Query (List.RemoveNull, List.Reverse, List.Transform).
Top Duration Players
Challenge No. 158: List the top 3 players in decreasing order of duration.
Solved using: Python in Excel.
Find Pythagorean Dates
Challenge No. 156: Pythagorean dates are those dates where DD^2 + MM^2 = YY^2
For example: 16-Dec-2020 where 16^2 + 12 ^2 = 20^2
List all Pythagorean dates (in YYYYMMDD format) from current century.
Solved using: Python in Excel.
Polybius Cipher Encrypt
Challenge No. 155: Polybius cipher
Encrypt the text in column I as per grid in A2:G8.
Solved using: Python in Excel.