Challenge No. 681: Split and align the data as shown.
Solved using: Python in Excel.
IFNA
Returns a custom value if a formula results in #N/A in Excel.
Track Quality Test Rounds
Challenge No. 664: After 3 rounds of quality testing, list the remaining batches from Round0 after each Round.
Solved using: Python in Excel.
List Words with Three Vowels
Challenge No. 622: Generate the list of words which contain at least 3 different vowels.
Solved using: R.
Top 3 Salespersons per Quarter
Challenge No. 619: List the top 3 salespersons for every quarter on the basis of total sales in that quarter.
Solved using: Python.
Populate the addresses for Greek
Challenge No. 264: Populate the addresses for Greek alphabets appearing in the grid.
Solved using: Python in Excel.
First and Last Number Sum
Challenge No. 544: Extract the first and last set of numbers appearing in A2:A10 and sum them.
Solved using: R.
Unstack Columns to Rows
Challenge No. 243: Transform the problem table into result table as shown.
Solved using: Python.
Align Rowwise Data
Challenge No. 520: Align the data as given in answer expected.
Solved using: Python in Excel.
Reshape Wide Table Format
Challenge No. 224: Transpose the problem table into result table.
Solved using: Python.
List Subject Pass Students
Challenge No. 222: Marks for various tests are given in problem table.
Solved using: R.