Challenge No. 688: Sum all the numbers given in column A except the first and last numbers in every cell.
Solved using: R.
IFERROR
Returns a custom value if a formula results in an error in Excel.
Align Names With Amounts
Challenge No. 684: Align Name and amounts together as shown.
Solved using: R.
Calculate Daily Work Hours
Challenge No. 639: Find the total time in hours worked on each day.
Solved using: Python in Excel.
Calculate Red Highlighted Area
Challenge No. 604: Today’s problem is contributed by Ahmad Syawal Ramli
Generate the area enclosed in red from problem table.
Solved using: Power Query.
Maximum Profit from Transactions
Challenge No. 561: For each row, you need to buy first and sell second.
Solved using: Python in Excel.
Top Two Department Salaries
Challenge No. 543: Find out the top 2 salaries in all departments.
Solved using: Python in Excel.
Signed Number String Sum
Challenge No. 529: Extract the numbers and sum them along with their signs.
Solved using: Python in Excel.
Clean Salary and Promotion Data
Challenge No. 226: Clean the given data and align them properly in departments and sort on Dept ID & Names.
Solved using: Python in Excel.
Repeat Pythagorean Triplet Finder
Challenge No. 491: Pythagorean Triplets follow the rule a^2 + b^2 = c^2
Find a, b, c where a + b + c = Sum (which is column A).
Solved using: Python in Excel.
Find Pythagorean Triplets
Challenge No. 484: Pythagorean Triplets follow the rule a^2 + b^2 = c^2
Find a, b, c where a + b + c = Sum (which is column A).
Solved using: Python in Excel.