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.
LET
Assigns names to values or calculations to simplify formulas in Excel.
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.
Find Matches with Same Goals
Challenge No. 61: List the matches where total goals scored are same.
Solved using: Excel VBA.
Workdays in Each Year
Challenge No. 59: In 21st century (i.e.
Solved using: Power Query.
Random Selection! Part 1
Challenge No. 93: Randomly select a staff member from each department.
Solved using:Excel (FILTER, HSTACK, INDEX), Google Sheets, Power Query (Table.Group), Python, Python in Excel, and R.
List 2nd and 4th Saturdays
Challenge No. 56: Provide a formula to generate the list of 2nd and 4th Saturdays for a given quarter and year in A1.
Solved using: Power Query.
Missing Values! Part 3
Challenge No. 92: In the question table, some cells (highlighted) are missing, but a character determines how to fill them based on the following rule:
R = right cell
L = left cell
U = upper cell
D = down cell.
Solved using:Excel (IF, IFS, INDEX), Power Query (List.PositionOf, List.Transform), Python, Python in Excel, and R.
Find Last Mondays after 25th
Challenge No. 52: Provide a formula to list the Last Mondays of each month for a given year in A1 if Last Monday falls on a day > 25.
Solved using: DAX.
Create Number Blocks From a Text String
Challenge No. 11: Create blocks based on the sets of text number strings.
Solved using: Power Query.
Sum Tenure of US Presidents
Challenge No. 51: Provide a formula to calculate the total (sum) years of tenure of all US presidents.
Solved using: Power Query.