Challenge No. 251: Find those numbers which when multiplied by 2 to number of digits in that number generates the same digits in any other order.
Solved using: Power Query.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Add Index Column! Part 5
Challenge No. 154: Add an index column to the question table, which has the same index value for every consecutive date.
Solved using:Excel (DROP, IF, LAMBDA), Google Sheets, Power Query (Table.AddColumn, Table.AddIndexColumn, Table.Column), Python, Python in Excel, and R.
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.
Calculate Percentage of Correct Answers
Challenge No. 83: Generate result table where Y means that right answer has been chosen and N means wrong answer has been chosen.
Solved using: Power Query (List.Distinct, Table.AddColumn).
Multiply Digits to Single Digit
Challenge No. 249: Multiply first digit with second digit, then result of this should be multiplied with 3rd digit and so on.
Solved using: Power Query.
Custom Grouping! Part 10
Challenge No. 153: The table includes two columns, From and To, where each row represents a range of dates.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Table.Group), Python, Python in Excel, and R.
Month and Quarter by Index
Challenge No. 248: Print the name of month & quarter as per position of 1.
Solved using: Power Query.
Case-Sensitive Reverse Cipher
Challenge No. 247: This problem is an extension of first challenge.
Solved using: Excel VBA.
Sort Words by End Digit
Challenge No. 246: All words have a one digit number as its last character.
Solved using: Power Query.
Top 3 Students Per Subject
Challenge No. 81: Generate Top 3 students in all subjects.
Solved using: Power Query.