Challenge No. 105: Find the counts of weekday names of Christmas during last n years mentioned in A1.
Solved using: SQL.
SEQUENCE
Generates a sequence of numbers in an array in Excel.
Generate Fibonacci Strings
Challenge No. 104: Generate n Fibonacci strings for given first two terms.
Solved using: SQL.
Caesar Cipher Multi Shift
Challenge No. 103: This is the 3rd in series of Caesar’s Cipher Challenges.
Solved using: SQL.
Generate Italian Fiscal Code
Challenge No. 102: This is first part of 2 parts Italian Fiscal Code (Codice Fiscale) generation challenges.
Solved using: SQL.
Replace with Past Vowels
Challenge No. 100: The string contains only English alphabets.
Solved using: SQL.
Count Unique Odd Digit Numbers
Challenge No. 97: Yesterday, I ended up posting a complex challenge.
Solved using: Python in Excel.
Pair clubs so each team
Challenge No. 27: There are 9 clubs and every club has to play with remaining 8 clubs once only.
Solved using: Power Query (Table.AddColumn).
Draw Descending Triangle
Challenge No. 93: Draw the triangle as per number given in A1.
Solved using: Python.
List Valid EAN-13 Numbers
Challenge No. 91: Provide a formula to list down all valid EAN-13 numbers.
Solved using: Python in Excel.
Generate Tabula Recta Grid
Challenge No. 88: Generate the given grid.
Solved using: Python.