Challenge No. 444: Look & Say Sequence
Going from Left to Right in a number, take a digit and insert how many times this digit appears to the left of the digit.
Solved using: Python in Excel.
LAMBDA
Creates custom reusable functions in Excel.
Extract Valid Structured Words
Challenge No. 191: Extract the words which are either numbers followed by all uppercase English letters or vice versa.
Solved using: Python in Excel.
Delete Duplicate Rows
Challenge No. 58: Delete rows with duplicate Invoice, User & Dept, whose values can be completely Offset.
Solved using: Python.
Find Birds in Grid Rows
Challenge No. 443: Given 10×10 grid in A2:K11 contains bird names across rows (not in columns).
Solved using: Python in Excel.
Encrypt Using Columnar Cipher
Challenge No. 442: Columnar Transposition Cipher
Write the keyword in a row
Rank the letters of keyword as per their position in English language in descending order.
Solved using: Python in Excel.
Split Data by Capital Letters
Challenge No. 190: Split the data into columns.
Solved using: R.
Generate Integers From Ranges
Challenge No. 441: Generate the integers corresponding to intervals.
Solved using: Python.
Allocate Amounts by Quarter Days
Challenge No. 188: Divide the amount across quarters falling in between From and To Date.
Solved using: Python in Excel.
Interpolate Grid Position Values
Challenge No. 440: Today’s challenge is proposed by Sunny Baggu
a is for row 1 and b is for column 1.
Solved using: Python in Excel.
Find Interpolated Grid Values
Challenge No. 439: Today’s challenge is proposed by Sunny Baggu
a is for row 1 and b is for column 1.
Solved using: Python in Excel.