Challenge No. 274: List those numbers when a number is multiplied by 2 once and 3 once and we join the original number with results of these multiplications, then the result should contain all digits from 0 through 9.
Solved using: Python in Excel.
SEQUENCE
Generates a sequence of numbers in an array in Excel.
List Autobiographical Numbers
Challenge No. 273: List all numbers which are Autobiographical numbers.
Solved using: Python in Excel.
Find Max Substring from Length
Challenge No. 271: Cut all substrings from column A of length given in column B and find the max.
Solved using: Python in Excel.
Remove Consecutive Repeated Digits
Challenge No. 269: Remove consecutive digits from the number.
Solved using: Excel VBA.
Decrypt Baconian Cipher Text
Challenge No. 268: Find the Decrypted words corresponding to Encrypted words .
Solved using: Excel VBA.
Check Digit Occurrence Validity
Challenge No. 266: List those numbers only where odd digits appear odd number of times and even digits appear even number of times.
Solved using: Excel VBA.
Mark Repeats in Date Column
Challenge No. 91: Transpose the problem table into result table.
Solved using: Power Query (Table.AddColumn, Table.SelectRows).
Find Isogram Calendar Dates
Challenge No. 265: An Isogram date is a two digits year date in which no digit occurs more than once.
Solved using: Power Query.
Match Reverse Word Containment
Challenge No. 264: Ananyms are words in reverse.
Solved using: Power Query.
Insert Increasing Header Intervals
Challenge No. 90: Insert header row after 1 name, then after 2 names, then after 3 names and so on.
Solved using: Power Query.