Challenge No. 154: Convert from Roman to Decimal.
Solved using: Python in Excel.
LET
Assigns names to values or calculations to simplify formulas 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.
Common Digits in Row
Challenge No. 151: List the common digits between all the numbers in a row.
Solved using: Python in Excel.
Grouping Data
Challenge No. 38: Sort Cookies into 2 groups: with Duplicate Price & with Unique prices Dynamic array function allowed but
Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Perfect Numbers Detection
Challenge No. 149: List the perfect numbers from column A.
Solved using: Python in Excel.
Dso!
Challenge No. 118: Using the sales transactions from the provided table and the account balance as of 31/08/2024, calculate the Daily Sales Outstanding (DSO) for each customer.
Solved using:Excel, Google Sheets, Power Query, Python, Python in Excel, and R.
Rotate Grid by Count
Challenge No. 148: Rotate the grid given in A4:E7 as per values given in B1.
Solved using: Power Query.