Challenge No. 610: Find the number of un-common unique words between Sentence1 and Sentence2.
Solved using: Python.
ROWS
Returns the number of rows in an array or range in Excel.
Find Missing AP Sequence
Challenge No. 609: The first and last terms in an Arithmetic Progressions (AP) are given in each row.
Solved using: Python in Excel.
Unpivot the table, add order
Challenge No. 276: Unpivot the table.
Solved using: Python in Excel.
Top Three Column Products
Challenge No. 578: Find the top 3 max product from the combination of numbers from 3 columns (Number1, Number2, Number3).
Solved using: Python.
Calculate Name-Based Durations
Challenge No. 573: Work out the durations in hours against all names.
Solved using: Python.
Swap Letters by Index Pair
Challenge No. 570: For a given string, interchange the alphabets by swapping positions given in Numbers column.
Solved using: Python in Excel.
Sort Alternate Row Patterns
Challenge No. 555: Sort odd numbered rows into ascending order, even numbered rows into descending order and populate their corresponding cities in the result.
Solved using: Python.
Odd Numbers All Directions
Challenge No. 550: Last week, we had this challenge.
Solved using: Python in Excel.
Transpose the problem table into
Challenge No. 248: Transpose the problem table into result table.
Solved using: Python.
Get names in a sorted
Challenge No. 245: Get names in a sorted order under subject columns.
Solved using: Python in Excel.