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.
ROW
Returns the row number of a reference in Excel.
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.
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.
Unpivot the table, add order
Challenge No. 276: Unpivot the table.
Solved using: Python in Excel.
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.
Digit Sum in Fibonacci Sequence
Challenge No. 580: Let’s code golf.
Solved using: Python.
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.
Populate the addresses for Greek
Challenge No. 264: Populate the addresses for Greek alphabets appearing in the grid.
Solved using: Python in Excel.
Absolute Alphabet Frequency Difference
Challenge No. 569: Find the count of alphabets in String1 and String2 and take the absolute difference of count of common alphabets and retain the non-common ones, combine those alphabets along with their counts (sorted alphabetically).
Solved using: Python in Excel.