Challenge No. 159: Reverse all columns from Cities1 to Cities5.
Solved using: Power Query (List.RemoveNull, List.Reverse, List.Transform).
LAMBDA
Creates custom reusable functions in Excel.
Power!
Challenge No. 121: Create the given table for the continuous values of power and bases.
Solved using:Excel (LAMBDA, MAKEARRAY, ROW), Office Script, Power Query (List.Transform), and Python in Excel.
Workday Count Between Dates
Challenge No. 157: Find the number of workdays between two dates (From & To) for Weekends given in column E.
Solved using: Power Query (NETWORKDAYS.INTL).
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.
Convert Roman to Decimal
Challenge No. 154: Convert from Roman to Decimal.
Solved using: Python in Excel.
Find Customer Stats With Conditions
Challenge No. 44: Generate result table as shown.
Solved using: Python in Excel.
Convert to Binary Numbers
Challenge No. 153: Convert the given positive numbers to Binary numbers.
Solved using: Python in Excel.
Remove Words by Index
Challenge No. 152: Remove the Words from column A as per index in column B.
Solved using: Excel VBA.
Extract Running Total By Group
Challenge No. 43: Generate result table as shown.
Solved using: Excel VBA.
Custom Grouping! Part 4
Challenge No. 119: The stock prices for the given dates are provided in the table.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Table.Group, Table.AddColumn, Table.Group), Python in Excel, and R.