Challenge No. 153: Convert the given positive numbers to Binary numbers.
Solved using: Python in Excel.
Condition Formatting
Challenge No. 39: Condition Format Project days Excluding Weekend
e.
Solved using: R.
Extract Running Total By Group
Challenge No. 43: Generate result table as shown.
Solved using: Excel VBA.
Remove Words by Index
Challenge No. 152: Remove the Words from column A as per index in column B.
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.
Generate Sales Figures Per Category
Challenge No. 42: A row appears for an alphabet if seq is continuous.
Solved using: SQL.
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.