Challenge No. 697: Document Pass or Fail against all students.
Solved using: Python in Excel.
List.Contains
Checks if a list contains a specified value in Power Query.
Classify Password Strength
Challenge No. 250: Classify the given passwords as
Invalid – If less than 8 characters
If >= 8 Characters
Weak – Contains only alphabets or only numbers or only special characters
Strong – Contains either alphabets+numbers or alphabets+special characters or numbers+special characters
Very Strong – Contains all 3 i.
Solved using: Excel VBA.
Sum Values by Letter Codes
Challenge No. 77: Generate the result table from problem table.
Solved using: Python in Excel.
Caesar Cipher Multi Shift
Challenge No. 103: This is the 3rd in series of Caesar’s Cipher Challenges.
Solved using: SQL.
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.
Purchasing Together!
Challenge No. 51: In the Question Table, historical sales data are provided.
Solved using:Excel (BYROW, HSTACK, LAMBDA), Power Query (List.Contains, List.ContainsAll, List.Transform), Python, and R.