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.
SEQUENCE
Generates a sequence of numbers in an array in Excel.
Pascal Case to Snake Case
Challenge No. 84: Change Pascal Case to Snake Case.
Solved using: Python in Excel.
Reverse Words in String
Challenge No. 82: Reverse the Words in the string.
Solved using: SQL.
Swap Alternate Rows
Challenge No. 81: Interchange the position of 1st row with 2nd, 3rd with 4th, 5th with 6th and so on.
Solved using: SQL.
List 1st, 3rd, 5th Saturdays
Challenge No. 80: List the 1st, 3rd and 5th Saturdays of all months for a given year in A1.
Solved using: Power Query.
Linear Interpolation!
Challenge No. 97: In the question table, the population data for cities A, B, and C are provided for different years.
Solved using:Excel, Google Sheets, Power Query, Python, Python in Excel, and R.
Find Palindromic Dates
Challenge No. 68: List the Palindrome dates in 21st century i.
Solved using: Python in Excel.
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.
Count Prime Numbers in Range
Challenge No. 58: Count prime numbers between given Lower and Upper Limits.
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.