Challenge No. 87: Generate the result table which has the count of different age groups.
Solved using: Python in Excel.
COUNTIFS
Counts the number of cells meeting multiple criteria in Excel.
Duplicate Values! Part 1
Challenge No. 100: Consider the IDs in the question table.
Solved using:Excel (CHAR, COUNTIF, COUNTIFS), Google Sheets, Power Query (List.Transform, Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Flag Columns with Special Keys
Challenge No. 24: Generate the result table.
Solved using: Power Query (List.Distinct).
Find Common Animals
Challenge No. 13: Provide a formula to generate the list of animals who are common in all 3 columns.
Solved using: Python in Excel.
List Numbers Appearing Repeatedly
Challenge No. 6: Provide a formula to list numbers which appear more than once in Range A2:A20 and have both B and C in B2:B20.
Solved using: Python in Excel.