Challenge No. 184: List the years in this century which are having at least 2 months which had 5 Fridays, 5 Saturdays and 5 Sundays.
Solved using: Python in Excel.
⭐️ Beginner
Easy challenges for newcomers.
List Tetradic Numbers
Challenge No. 183: List Tetradic numbers from column A.
Solved using: Python in Excel.
Fill Arithmetic Progression
Challenge No. 182: Find the missing numbers in Arithmetic Progressions given.
Solved using: Python in Excel.
Max Items Within Budget
Challenge No. 180: Provide a formula to list the maximum number of items (one unit only of each item) which can be bought in $150 from A2:A10.
Solved using: Power Query (Table.Sort).
Remove Consecutive Duplicates
Challenge No. 179: If a character appears consecutively, then remove all consecutive characters other than first.
Solved using: Excel VBA.
Route Cipher Encrypt
Challenge No. 178: Route Cipher
Encrypt the given Strings.
Solved using: Power Query.
Common Digits with Frequency
Challenge No. 177: Find the common digits between Number1 and Number2 if the occurrence frequency of a digit is same in both Number1 and Number2 and occurrence frequency of that digit > 1.
Solved using: Power Query (List.Transform).
Name Team Statement
Challenge No. 176: If a single name => name followed by “is in team”.
Solved using: Power Query.
Common Words Between Sentences
Challenge No. 175: Find the common words between Sentence1 and Sentence 2 and sort the common words.
Solved using: Power Query (Text.Split).
Extract Last Odd Numbers
Challenge No. 174: Extract the last n odd numbers.
Solved using: Excel VBA.