Challenge No. 690: The value associated with alphabets are given in the grid next to the alphabets.
Solved using: Python in Excel.
IFS
Returns a value corresponding to the first TRUE condition in Excel.
Detect Sequence Direction
Challenge No. 655: Find whether a sequence is increasing (I), decreasing (D) or neither of these (N).
Solved using: Python.
Draw ASCII Abacus Display
Challenge No. 553: Draw an ASCII abacus.
Solved using: Python in Excel.
Pivot for Time Entries by Date
Challenge No. 418: Pivot the given table for Date / Emp ID combinations with Min and Max Time.
Solved using: Python in Excel.
Find Min and Max for all zones
Challenge No. 332: Find the Max and Min for all Zones.
Solved using: Python in Excel.
Teams With No Losses
Challenge No. 280: List the Teams which have never lost even a single game.
Solved using: Python in Excel.
Classify Sentence Text Case
Challenge No. 270: Classify the sentences as per case
All Lowercase – All letters in lowercase
All Caps – All letters in uppercase
Start Case – First letters of all words in uppercase
Sentence Case – Only first letter of first word in uppercase
Mixed Case – Not following any of the rules above.
Solved using: Python in Excel.
Mark Repeats in Date Column
Challenge No. 91: Transpose the problem table into result table.
Solved using: Power Query (Table.AddColumn, Table.SelectRows).
Count of People by Age Group
Challenge No. 87: Generate the result table which has the count of different age groups.
Solved using: Python in Excel.
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.