Challenge No. 43: Group the staff into their respective salary ranges
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
MAP
Applies a function to each element of one or more arrays in Excel.
Generate First Disarium List
Challenge No. 164: A Disarium number is that number where sum of each digit raised to the power of its position in the number is equal to number itself.
Solved using: Python in Excel.
Determine Result Table Based on Rules
Challenge No. 47: Count the process groups as given.
Solved using: Power Query.
Symbol Replace by Frequency
Challenge No. 163: If an alphabet appears once in a word, replace it with a “?”.
Solved using: Power Query (Table.AddColumn).
Vernam Cipher Encrypt
Challenge No. 162: Vernam Cipher (also known as One time pad cipher)
1.
Solved using: Power Query (List.ReplaceMatchingItems, List.Transform, List.Zip).
Reverse Long Words
Challenge No. 161: If a word in sentence has length > Number, then reverse that word.
Solved using: Power Query (Text.Combine).
Alphabet Prime Mapping
Challenge No. 160: Generate first 26 prime numbers starting with 2 till 101 (101 is 26th prime number).
Solved using: Python in Excel.
Workday Count Between Dates
Challenge No. 157: Find the number of workdays between two dates (From & To) for Weekends given in column E.
Solved using: Power Query (NETWORKDAYS.INTL).
Polybius Cipher Encrypt
Challenge No. 155: Polybius cipher
Encrypt the text in column I as per grid in A2:G8.
Solved using: Python in Excel.
Convert to Binary Numbers
Challenge No. 153: Convert the given positive numbers to Binary numbers.
Solved using: Python in Excel.