Challenge No. 49: Provide a formula to list those numbers in A2:A10 where every succeeding digit is >= previous digit.
Solved using: Python in Excel.
DROP
Removes a specified number of rows or columns from an array in Excel.
Find Last Group of Missing Numbers
Challenge No. 42: Provide a formula to find last group of missing numbers.
Solved using: Power Query.
Total Distance!
Challenge No. 81: The distance between cities and staff travels are provided in the question distance and travel tables.
Solved using:Excel (DROP, IFNA, INDEX), Power Query (Table.AddColumn), Python, and R.
Character-Based Rhombus
Challenge No. 77: Create a formula to receive a number n as input and generate a rhombus with a diameter equal to n using “*” characters.
Solved using:Excel (DROP, IF, LAMBDA), Power Query (List.Transform), Python, R, and VBA.
Custom Splitter (Part 2)!
Challenge No. 73: In the Question table, sales information including Date, Product Names, and quantity are provided without any separators like CH 63 with the difference that on each date, more than one transaction might provided.
Solved using:Excel (CHAR, DROP, HSTACK), Power Query (List.Skip, List.Transform, Table.AddColumn), Python, and R.
Merged Cells!
Challenge No. 66: Convert the Question table with the merge headers into the result table.
Solved using:Excel (DROP, HSTACK, IF), Power Query (List.Distinct, List.PositionOf, Table.Pivot), Python, R, and VBA.
Text Cleaning!
Challenge No. 64: In the Question table, historical sales values are provided in a single cell, including the Date, Product Name, and Quantity, with a default value of 1 for missing quantities.
Solved using:Excel (DROP, HSTACK, IFERROR), Power Query (List.Transform, Text.Split, Table.Split), Python, R, and VBA.
Missing Values! Part 2
Challenge No. 62: The question table presents the actual progress of 3 projects at the end of each month, but some values are missing.
Solved using:Excel (DATE, DROP, IF), Power Query (Date.Month), Python, and R.
Match Payments!
Challenge No. 60: The customer receipt costs and their payments are provided in Question Tables 1 and 2.
Solved using:Excel, Power Query, and R.
Process Efficiency!
Challenge No. 56: In Question Table 2, the sequence of machinery based on the process type is presented, and historical machinery data is provided in Question Table 1.
Solved using:Excel, and Power Query.