Challenge No. 471: Decrypt the Encrypted Text using Keyword Cipher.
Solved using: Python in Excel.
XLOOKUP
Searches a range for a value and returns a corresponding result in Excel.
Calculate Monthly Inventories
Challenge No. 463: Calculate the inventory at the end of all months of the year.
Solved using: Python in Excel.
Convert Resistance to Ohms Unit
Challenge No. 438: Now, let’s express the derived values as K, M or G (Kilo, Mega or Giga).
Solved using: Python in Excel.
Match Deliveries with Calendar Dates
Challenge No. 186: Merge both the tables.
Solved using: Python in Excel.
Decode Color Band Resistance
Challenge No. 420: For the given color bands in Column E, work out the total resistance.
Solved using: Python in Excel.
Generate Kamasutra Cipher Encryption
Challenge No. 382: Kamasutra Cipher – Generate 13 random pairs from English alphabets and use that to encrypt the plain text.
Solved using: Python.
Encrypt Text with Keyword Cipher
Challenge No. 377: Encrypt the gives words using Keyword Cipher.
Solved using: Python.
Column Combining! Part 1
Challenge No. 189: Given multiple columns, concatenate them based on a predefined pattern.
Solved using:Excel (BYROW, CONCAT, IF), Google Sheets, Power Query (List.ReplaceMatchingItems, List.Transform, List.Zip), Python, Python in Excel, and R.
Lookup and Sum
Challenge No. 44: Summarise the budget per Department
For example, Using the Lookup table, the total Finance budget is
“Treasury (278)+Budgeting (748)”.
Solved using: Python.
Mark Repeats in Date Column
Challenge No. 91: Transpose the problem table into result table.
Solved using: Power Query (Table.AddColumn, Table.SelectRows).