Challenge No. 700: Pivot the given data by summing up the values.
Solved using: Python.
TOCOL
Converts a range or array into a single column in Excel.
Team with All Wins
Challenge No. 692: List the team which won all their matches.
Solved using: Python in Excel.
Sum of Values for Alphabets
Challenge No. 690: The value associated with alphabets are given in the grid next to the alphabets.
Solved using: Python in Excel.
Grid Lookup By Pattern
Challenge No. 683: Find the value corresponding to numbers given in column N from the grid given of left hand side.
Solved using: Python.
Split And Sum Orders
Challenge No. 682: In the problem table, if there are more than one order number, then amount will be equally divided among order numbers.
Solved using: Python.
Signed Permutation Generator
Challenge No. 675: This problem is contributed by Sunny Baggu
Given 2 input numbers, create all possible permutations considering numbers as both positive and negative.
Solved using: Python.
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.
Matrix Transformation Series
Challenge No. 661: Today’s challenge is contributed by 🇰🇷 Taeyong Shin
Converts the T1 matrix to a T2 matrix and the T2 matrix to a T3 matrix.
Solved using: Excel.
Generate Sequential Tickets
Challenge No. 652: Generate the ticket numbers as given.
Solved using: Python.
Bottom Three Unique Values
Challenge No. 650: List the bottom 3 unique values across the columns.
Solved using: Python.