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.
LAMBDA
Creates custom reusable functions 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.
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.
Weekly Count by Category
Challenge No. 572: Week 1 starts from 1st of the month.
Solved using: Python in Excel.
Rank stores by percentage of
Challenge No. 263: Table 1 (T1) has got customer satisfaction responses and Table 2 (T2) has got color coding of those responses.
Solved using: Python.