Assigns names to values or calculations to simplify formulas in Excel.
Challenge No. 165: Based on monthly transactions, categorize each customer for each month into one of the following groups:
New: A customer who has never made a purchase in previous months.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (Table.Group, List.Difference, List.Distinct), Python, and R.
Challenge No. 93: List the Maximum Amount and the Years in which these maximum amounts occurred.
Solved using: Python in Excel.
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.
Challenge No. 269: Remove consecutive digits from the number.
Solved using: Excel VBA.
Challenge No. 163: Convert the monthly sales data from the Question table into seasonal sales as shown in the Result table.
Solved using:Excel (FILTER, GROUPBY, HSTACK), Google Sheets, Power Query (Table.Group, Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Challenge No. 268: Find the Decrypted words corresponding to Encrypted words .
Solved using: Excel VBA.
Challenge No. 162: Separate the values inside the curly braces { }, do the same for nested curly braces.
Solved using:Excel (IFNA, LAMBDA, LET), Google Sheets, Power Query (List.Transform, Table.AddColumn), Python, Python in Excel, R, and VBA.
Challenge No. 91: Transpose the problem table into result table.
Solved using: Power Query (Table.AddColumn, Table.SelectRows).
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.
Challenge No. 265: An Isogram date is a two digits year date in which no digit occurs more than once.
Solved using: Power Query.
