Challenge No. 44: Summarise the budget per Department
For example, Using the Lookup table, the total Finance budget is
“Treasury (278)+Budgeting (748)”.
Solved using: Python.
⭐️ Beginner
Easy challenges for newcomers.
Find Palindrome Words in Text
Challenge No. 275: A Palindrome word is that which is same even when read backwards.
Solved using: Python in Excel.
Time Zone!
Challenge No. 166: In the provided table, the Date Time values correspond to different time zones (specified in the column GMT From).
Solved using:Excel (BYROW, HSTACK, LAMBDA), Google Sheets, Power Query (Text.End), Python, Python in Excel, and R.
Concatenated Multiples All Digits
Challenge No. 274: List those numbers when a number is multiplied by 2 once and 3 once and we join the original number with results of these multiplications, then the result should contain all digits from 0 through 9.
Solved using: Python in Excel.
List Autobiographical Numbers
Challenge No. 273: List all numbers which are Autobiographical numbers.
Solved using: Python in Excel.
Find Max Substring from Length
Challenge No. 271: Cut all substrings from column A of length given in column B and find the max.
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.
Remove Consecutive Repeated Digits
Challenge No. 269: Remove consecutive digits from the number.
Solved using: Excel VBA.
Decrypt Baconian Cipher Text
Challenge No. 268: Find the Decrypted words corresponding to Encrypted words .
Solved using: Excel VBA.
Check Digit Occurrence Validity
Challenge No. 266: List those numbers only where odd digits appear odd number of times and even digits appear even number of times.
Solved using: Excel VBA.