Challenge No. 239: Replace the vowels with vowels in sorted order.
Solved using: Excel VBA.
MATCH
Returns the relative position of a value in an array in Excel.
Custom Grouping! Part 7
Challenge No. 133: Group the monthly sales values into three categories based on the following logic and provide one of the result tables:
Group 1: 1st to 10th of the month
Group 2: 11th to 20th of the month
Group 3: 21st to the end of the month.
Solved using:Excel (DATE, DAY, DROP), Google Sheets, Power Query (Table.Group, Date.Month, Table.AddColumn), Python, Python in Excel, and R.
Find Missing Letters in Order
Challenge No. 193: Listed are the strings where letters are in increasing order.
Solved using: Power Query.
Fill Arithmetic Progression
Challenge No. 182: Find the missing numbers in Arithmetic Progressions given.
Solved using: Python in Excel.
Max Items Within Budget
Challenge No. 180: Provide a formula to list the maximum number of items (one unit only of each item) which can be bought in $150 from A2:A10.
Solved using: Power Query (Table.Sort).
Merge! Part 2
Challenge No. 124: In Question Table 1, dates and prices for a product are provided.
Solved using:Excel (INDEX, LAMBDA, LET), Google Sheets, Power Query (Table.AddColumn), Python, Python in Excel, and R.
Left Strip Given Chars
Challenge No. 127: Remove LSTRIP Chars from Input String from left side.
Solved using: Python in Excel.
Trim Underscores at Ends
Challenge No. 119: Remove the trailing and leading underscore characters.
Solved using: SQL.
Generate Italian Fiscal Code
Challenge No. 102: This is first part of 2 parts Italian Fiscal Code (Codice Fiscale) generation challenges.
Solved using: SQL.
Lookup and Get the Difference
Challenge No. 14: Rules:
Check Salary within Scale Table
If Exact within the table, (Salary-previous year Amount)
If between 2 years, get the difference between the two years
If No Previous Year, Return Zero
Strictly Legacy Array Functions or PowerQuery.
Solved using: Power Query.