Challenge No. 284: Find out unique combination of numbers from column A containing N numbers given in column B which sums to column C.
Solved using: Python in Excel.
Prime with Consecutive Digits Only
Challenge No. 283: A number should contain digits only from 1 through length of that number and should also be a prime.
Solved using: Python in Excel.
The Knight’S Tour!
Challenge No. 170: Given a N*N board with the Knight placed on the first block of an empty board.
Solved using:Excel, Python, and Python in Excel.
Calculate Quarterly Working Payment
Challenge No. 100: Per day rates for every person for a duration is given.
Solved using: Python in Excel.
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.
Find Divisible Substrings Sorted
Challenge No. 281: List all the substrings from Number1 which are divisible by Number2.
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).
Teams With No Losses
Challenge No. 280: List the Teams which have never lost even a single game.
Solved using: Python in Excel.
Data Extraction
Challenge No. 45: Extract the Date and Amount from the details
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solutions.
Solved using: Python.