Challenge No. 135: Generate the result table which is as per bin size.
Solved using: R.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Find Longest Consecutive Sequence
Challenge No. 347: List the largest group of consecutive numbers in each column.
Solved using: R.
Replace letters with nearest vowels
Challenge No. 346: The string contains only English alphabets.
Solved using: Python in Excel.
Sum digits along diagonals of grid
Challenge No. 345: Find the sum of digits of both the diagonals for the grids given.
Solved using: R.
List all Katadrome numbers
Challenge No. 344: List all Katadrome numbers.
Solved using: Python in Excel.
List valid South African National IDs
Challenge No. 342: List the valid South African National IDs (person identification numbers).
Solved using: Python in Excel.
Sort odd positioned numbers
Challenge No. 341: Sort the numbers at odd positions.
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.
Column Combining! Part 2
Challenge No. 199: Given multiple columns, concatenate them based on the order presented on the pattern column using space as a delimiter.
Solved using:Excel (BYROW, CHOOSECOLS, DROP), Google Sheets, Power Query (List.Transform, Text.Combine, Text.Split), Python, Python in Excel, and R.