Challenge No. 606: Merge rows on the basis of names.
Solved using: Python.
Detect Possible Date Formats
Challenge No. 605: Out of 3 date formats only, MDY, DMY & YMD, list the date formats for given dates.
Solved using: Python.
Calculate Red Highlighted Area
Challenge No. 604: Today’s problem is contributed by Ahmad Syawal Ramli
Generate the area enclosed in red from problem table.
Solved using: Power Query.
Identify Missing Number Ranges
Challenge No. 603: Find the missing numbers in the grid given between the smallest and the largest numbers.
Solved using: Python.
Transpose table, compute gross profit
Challenge No. 278: Transpose the table as shown where sum of amount shown is gross profit which is Revenue – Cost.
Solved using: Python.
Generate Clark’s Triangle Pattern
Challenge No. 602: Generate the Clark’s Triangle.
Solved using: Excel VBA.
Count Alphabetically Sorted Words
Challenge No. 601: Find the count of words in columns A through C if the words have sorted alphabets.
Solved using: Python in Excel.
Transpose the data as shown
Challenge No. 277: Transpose the data as shown.
Solved using: Python.
Find Smallest Uncreatable Sum
Challenge No. 600: What is the smallest sum which you can’t create using all or few of the coins given?
Ex.
Solved using: Python in Excel.
Match Words in Column Data
Challenge No. 599: Look up the Words (in column D) in Column1 and list the Result from Column2.
Solved using: Python.