Challenge No. 581: Populate 1 in first group of As and for every succeeding group of As, add 1 to the count.
Solved using: Python.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Digit Sum in Fibonacci Sequence
Challenge No. 580: Let’s code golf.
Solved using: Python.
Work out tiered running totals
Challenge No. 267: Work out the running total for first 10 entries, then next 9 entries, then next 8 entries till you reach 1 entry.
Solved using: Python.
Find Rotated Matching Words
Challenge No. 579: List the words from String1 and String2 if they are rotated versions of each other.
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.
Summarise the table with total
Challenge No. 266: Summarise the table as shown with a total row after each sales person’s data.
Solved using: Python.
Sort Consonants Keep Vowels
Challenge No. 576: Sort the consonants in given sentences while keeping the vowels wherever they are.
Solved using: Python.
Sort Odd Position Values
Challenge No. 574: Keep the numbers in even positions as it is and sort the numbers in odd positions.
Solved using: R.
Populate the addresses for Greek
Challenge No. 264: Populate the addresses for Greek alphabets appearing in the grid.
Solved using: Python in Excel.
Calculate Name-Based Durations
Challenge No. 573: Work out the durations in hours against all names.
Solved using: Python.