Challenge No. 58: Delete rows with duplicate Invoice, User & Dept, whose values can be completely Offset.
Solved using: Python.
TRIM
Removes extra spaces from a text string in Excel.
Remove letters in Planets column from Author Column
Challenge No. 315: Remove the English letters appearing in Planets column from Author Column.
Solved using: Python in Excel.
Identify Missing Brackets
Challenge No. 289: There are 3 types of Parentheses (brackets) – ( ), { }, [ ].
Solved using: Python in Excel.
Decode Numbered Character Words
Challenge No. 227: In column A, characters are separated by 1.
Solved using: Power Query.
Return Repeat Customers
Challenge No. 37: Return only dates with repeat customers and repeated customers Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Data Cleaning! Part 1
Challenge No. 98: In the Question table, historical sales values are provided in a single cell, including the Date, Product Name, and Quantity, but in a disorganized order.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (List.Transform, Text.Contains, Text.Split), Python, Python in Excel, and R.
Check Word Anagram Pair
Challenge No. 50: An anagram is a word or phrase formed by rearranging the letters of a different word or phrase, using all the original letters exactly once.
Solved using: Power Query.