Challenge No. 287: You will need to buy first and sell later.
Solved using: Python in Excel.
⭐️⭐️ Easy
Slightly challenging problems for learners.
List all Right Truncatable Primes
Challenge No. 286: List all Right Truncatable Primes.
Solved using: Python in Excel.
Table Transformation! Part 20
Challenge No. 171: Transform the question structure into the result structure.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Transform), Python, Python in Excel, and R.
Group Words by Anagrams
Challenge No. 282: An anagram is a word which is made by arranging the letters of another word.
Solved using: Python in Excel.
Extract From Text! Part 7
Challenge No. 169: Similar to Challenge 149, extract the texts between the pairs of the characters listed below.
Solved using:Excel (ARRAYTOTEXT, LAMBDA, MAP), Google Sheets, Power Query (List.Split, List.Transform, Text.Combine), Python, Python in Excel, and R.
Find Monthly Min Max Dates
Challenge No. 99: Find when the Min and Max occurred for various months and corresponding dates.
Solved using: Power Query (Text.Combine).
Reverse Only Vowels in Word
Challenge No. 279: Reverse only the vowels in the given words.
Solved using: Python in Excel.
Fill Grid With Left Values
Challenge No. 97: Fill in the grid with the immediate non-blank value on the left.
Solved using: Excel VBA.
List Year of Maximum Values
Challenge No. 93: List the Maximum Amount and the Years in which these maximum amounts occurred.
Solved using: Python in Excel.
Custom Grouping! Part 12
Challenge No. 163: Convert the monthly sales data from the Question table into seasonal sales as shown in the Result table.
Solved using:Excel (FILTER, GROUPBY, HSTACK), Google Sheets, Power Query (Table.Group, Table.AddColumn, Table.Group), Python, Python in Excel, and R.