Challenge No. 136: Find the common groups on the basis of common IDs.
Solved using: R.
UNIQUE
Returns unique values from a range or array in Excel.
List all Katadrome numbers
Challenge No. 344: List all Katadrome numbers.
Solved using: Python in Excel.
People Connection!
Challenge No. 200: In the question table, direct connections between people are provided.
Solved using:Excel (IF, IFNA, INDEX), Power Query (List.Transform, Text.End), Python, Python in Excel, and R.
Create half-yearly sorted table from data
Challenge No. 340: From dataset in column A, create the table under Answer Expected.
Solved using: Python in Excel.
Transpose First/Last Names
Challenge No. 131: Transpose the problem table into Result table.
Solved using: R.
Find unique number pairs
Challenge No. 336: Find the unique pair of numbers.
Solved using: Python in Excel.
Extract string before any letter repeats
Challenge No. 333: Extract the string before any alphabet is repeated.
Solved using: R.
Find Min and Max for all zones
Challenge No. 332: Find the Max and Min for all Zones.
Solved using: Python in Excel.
Top 3 marks with names and subjects
Challenge No. 327: List the top 3 marks and names and subjects against them.
Solved using: Python in Excel.
Find palindromic substrings with at least 3 digits
Challenge No. 323: Find the substrings of given numbers which are Palindromic.
Solved using: DAX.