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.
⭐️⭐️⭐️ Intermediate
Moderate difficulty level.
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.
Unique Animals by Column
Challenge No. 57: Provide a formula to generate the list of unique animals from columns taking one column at a time who don’t appear in any other column.
Solved using: Python in Excel.
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.
Split, Multiply and Sum a Text String
Challenge No. 12: Calculate total sales
Strictly Legacy array function
Abdallah Ally Bhavya Gupta Richard Nero.
Solved using: Power Query.
Top Three Students Report
Challenge No. 15: (Excel formulas also welcome)
Generate Top 3 students in all subjects.
Solved using: Power Query.
Return a Date given the Month, Year, Day of the Week and Occurrence
Challenge No. 7: Return a Date given the Month, Year, Day of the Week and Occurrence Strictly Legacy Array Functions or PowerQuery.
Solved using: Power Query.
Split and Sum a Text String Using a Criteria
Challenge No. 10: Sum only quantities above 100
Strictly use the Legacy array function or Power Query.
Solved using: Power Query.
Longest Palindromic Word
Challenge No. 47: Palindromes are those words which are same even when read from backwards.
Solved using: Python in Excel.