Challenge No. 182: Let’s do reverse of yesterday’s problem.
Solved using: Python.
UNIQUE
Returns unique values from a range or array in Excel.
Sales Year Monthly Summary
Challenge No. 179: Generate the result table from problem table.
Solved using: R.
Pivot Using Suffix Headers
Challenge No. 413: Pivot the given data with headers suffixed with 1, 2.
Solved using: Python.
Weekday Weekend Sales Report
Challenge No. 170: Calculate the sum of sale for Weekdays and Weekends.
Solved using: Python in Excel.
Count Unique Letters in String
Challenge No. 399: Extract the unique alphabets from the given strings and count their frequencies of occurrence.
Solved using: Python.
Fill Missing Months Default
Challenge No. 159: For a give name and year combination, if a month is missing between 1 and 12 then enter that month number with a default sales of 100.
Solved using: Python in Excel.
Extract Signed Numbers from Text
Challenge No. 383: Extract the unique positive and negative numbers if they are immediately preceded by either plus or minus sign.
Solved using: Python.
Encrypt Text with Keyword Cipher
Challenge No. 377: Encrypt the gives words using Keyword Cipher.
Solved using: Python.
Find Palindromes by One Deletion
Challenge No. 374: A Palindrome word is that which is same even read backwards.
Solved using: Python in Excel.
Fruit Pair Frequency Grid
Challenge No. 148: Generate the grid shown where count need to be populated at intersections of rows and columns.
Solved using: Python.