Challenge No. 614: Today’s challenge is contributed by Mehmet Çiçek.
Solved using: R.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Match Names with Same Initials
Challenge No. 612: List the names if first character of first name and first character of last name are same.
Solved using: Python.
Find Maximum N-Digit Grid Number
Challenge No. 611: Find the N digit maximum number in given 6×6 grid either rows (left to right) or columns (top to down).
Solved using: Python.
Count Unique Uncommon Words
Challenge No. 610: Find the number of un-common unique words between Sentence1 and Sentence2.
Solved using: Python.
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.
Extract Zip and Country Info
Challenge No. 608: Extract zip code (5 or 6 digits in length) and country names.
Solved using: Python.
Merge and Sort Name Rows
Challenge No. 606: Merge rows on the basis of names.
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.