Challenge No. 100: Consider the IDs in the question table.
Solved using:Excel (CHAR, COUNTIF, COUNTIFS), Google Sheets, Power Query (List.Transform, Table.AddColumn, Table.Group), Python, Python in Excel, and R.
CHAR
Returns the character associated with a numeric code in Excel.
Pascal Case to Snake Case
Challenge No. 84: Change Pascal Case to Snake Case.
Solved using: Python in Excel.
Generate A to Z letter sequence
Challenge No. 33: Provide a formula to generate the sequence shown (A till Z only).
Solved using: Power Query (List.Transform).
Count Letters and Digits
Challenge No. 7: Provide a formula to count the number of English alphabets and numeric digits in every cell.
Solved using: Python in Excel.
Custom Splitter (Part 2)!
Challenge No. 73: In the Question table, sales information including Date, Product Names, and quantity are provided without any separators like CH 63 with the difference that on each date, more than one transaction might provided.
Solved using:Excel (CHAR, DROP, HSTACK), Power Query (List.Skip, List.Transform, Table.AddColumn), Python, and R.
Custom Splitter!
Challenge No. 63: In the Question table, sales information including Date, Product Name, and Quantity is provided without any separators.
Solved using:Excel (CHAR, HSTACK, LAMBDA), Power Query (List.Contains, Table.Combine, Table.FromRows), Python, R, and VBA.