Challenge No. 146: A Pangram (also known as Holoalphabetic) sentence is that which contains all 26 letters of English alphabets at least once.
Solved using: Power Query (Table.SelectRows).
⭐️ Beginner
Easy challenges for newcomers.
Add Index Column! Part 3
Challenge No. 117: Add an Index column for the Question table with a separate counter for each stock.
Solved using:Excel (COUNTIF, HSTACK, IF), Google Sheets, Power Query (Table.AddIndexColumn, Table.Group, Table.Sort), Python, Python in Excel, and R.
Match Acronyms with Words
Challenge No. 144: Match the Acronyms given in column C against the words given in column A.
Solved using: SQL.
Dynamic Pivot Data
Challenge No. 36: Create a dynamic solution to analyse tests per student
Minimize the steps/functions used
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
List Harshad Numbers
Challenge No. 143: List the numbers which are Harshad number (also known as Niven number or Multidigital number).
Solved using: Python in Excel.
Grid Sum Generation
Challenge No. 142: Generate the result grid which is the sum of input grid.
Solved using: Python in Excel.
Next Palindrome Number
Challenge No. 141: Palindrome number is that which is same even when read backwards.
Solved using: Python in Excel.
Populate Start & End Date from a month name
Challenge No. 35: Populate Project Start & End Dates Given Start Month & Duration Assume Start (1st of Month) & End (Last day of Month)
Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Common Letters Sorted
Challenge No. 140: List the common letters between Word1 and Word2 and sort them alphabetically.
Solved using: Power Query (List.Distinct, Table.AddColumn).
Top Initial Letters Count
Challenge No. 138: Find the top 5 highest occurring starting alphabets of words in US Presidents columns.
Solved using: Python in Excel.