Challenge No. 634: Starting the week on a comfortable note.
Solved using: R.
TEXTSPLIT
Splits a text string into an array based on delimiters in Excel.
Count Unique Uncommon Words
Challenge No. 610: Find the number of un-common unique words between Sentence1 and Sentence2.
Solved using: Python.
Extract Zip and Country Info
Challenge No. 608: Extract zip code (5 or 6 digits in length) and country names.
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.
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.
Transpose the data as shown
Challenge No. 277: Transpose the data as shown.
Solved using: Python.
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.
Transpose the table as shown
Challenge No. 273: Transpose the table as shown.
Solved using: Python.
Cross Product with Repeats
Challenge No. 585: Prepare the cross product of Column1 with Column2 where an entry should be repeated by the number in brackets.
Solved using: Python.
Cross Product with Multiples
Challenge No. 584: Prepare the cross product of Column1 with Column2 where an entry should be repeated by the number in brackets.
Solved using: R.