Challenge No. 218: Transpose the table as shown.
Solved using: Python in Excel.
UNIQUE
Returns unique values from a range or array in Excel.
Sort Zoo Records Alphabetically
Challenge No. 214: Align the data as per Zoo and sort them alphabetically.
Solved using: DAX.
Matrix Merge With Totals
Challenge No. 213: Merge the 2 tables and pivot them on Item with Total Row and Total Column.
Solved using: Python in Excel.
Score Matrix for Team Matches
Challenge No. 482: Prepare the given matrix from problem table.
Solved using: Python in Excel.
Decrypt Keyword Cipher Text
Challenge No. 471: Decrypt the Encrypted Text using Keyword Cipher.
Solved using: Python in Excel.
Rank by Demand
Challenge No. 64: Rank the Fruits Based on Demand
e.
Solved using: Python.
Merge Subject Maximum Marks
Challenge No. 200: Merge the two tables by taking maximum marks of the subject.
Solved using: Python in Excel.
Transpose Marks with Subjects
Challenge No. 196: Transpose the problem table into result table.
Solved using: Python in Excel.
Common Entries and Count
Challenge No. 453: Today’s challenge is contributed by Mehmet Çiçek
Find the common entries in List1 and List2 and common count.
Solved using: Excel VBA.
Max Consecutive Number Streak
Challenge No. 451: Find the positive and negative numbers which occur consecutively maximum number of times.
Solved using: Python in Excel.