Challenge No. 64: List the numbers which have got any digits repeated.
Solved using: Python in Excel.
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.
Top Three Frequent Alphabets
Challenge No. 63: Provide a formula to list the top 3 highest occurring English alphabets in A2:A47 along with their frequencies.
Solved using: Power Query.
Two-Column Text!
Challenge No. 94: In the question table, texts are provided for different groups.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Split, List.Transform, Table.ExpandTableColumn), Python, Python in Excel, and R.
Pair Semi-Final Cricket Teams
Challenge No. 62: This challenge is inspired from ongoing T20 Cricket World cup.
Solved using: Power Query.
Count Out-In Quarter Difference
Challenge No. 18: (Excel formulas also welcome)
List the count of quarters for only those rows where Out Quarter > In Quarter.
Solved using: Power Query.
Find Matches with Same Goals
Challenge No. 61: List the matches where total goals scored are same.
Solved using: Excel VBA.
Generate Sum with Conditions
Challenge No. 60: There are two tables.
Solved using: Power Query.
Clean and Sum a Text String
Challenge No. 13: Calculate the remaining visits
Strictly Legacy array function or PowerQuery.
Solved using: Python in Excel.
Workdays in Each Year
Challenge No. 59: In 21st century (i.e.
Solved using: Power Query.