Challenge No. 216: List the Vice Presidents who have been presidents also and list their vice-presidency and presidency years separated by comma.
Solved using: Power Query.
⭐️ Beginner
Easy challenges for newcomers.
Number Each Character
Challenge No. 209: Insert 1., 2.
Solved using: Power Query (List.Transform).
Sum Bird Quantity Alphabetically
Challenge No. 64: Looks like yesterday’s problem was a difficult one as only one person responded.
Solved using: Power Query (Table.Group, Table.Sort).
Pay All Quarters Customers
Challenge No. 208: Find those customers who have made at least one payment in all quarters in its range.
Solved using: Power Query.
Top Net Salary Earner
Challenge No. 205: Table 1 has salary for different names and Table 2 has percentage deduction applicable for various salary ranges.
Solved using: Python in Excel.
List All Dudeney Numbers
Challenge No. 204: A Dudeney number is a positive integer that is a perfect cube such that the sum of its decimal digits is equal to the cube root of the number.
Solved using: Power Query (List.Transform).
Encrypt Using Baconian Cipher
Challenge No. 203: Baconian Cipher
(This problem is case insensitive)
A is 0, B is 1, C is 2.
Solved using: Power Query.
Next Distinct Digit Number
Challenge No. 201: Find the next number which is having all digits distinct.
Solved using: Python in Excel.
List Isogram Words Only
Challenge No. 200: List all isograms from column A – An isogram is that word where letters occur same number of times
Ex.
Solved using: Power Query.
Detect Operators Between Numbers
Challenge No. 198: List the operator which operates between Number 1 and Number 2.
Solved using: Python in Excel.