Challenge No. 691: Give the rank1 and rank2 as shown.
Solved using: Python.
SORT
Sorts an array in ascending or descending order in Excel.
Sum of Values for Alphabets
Challenge No. 690: The value associated with alphabets are given in the grid next to the alphabets.
Solved using: Python in Excel.
Bottom Three Unique Values
Challenge No. 650: List the bottom 3 unique values across the columns.
Solved using: Python.
Identify Yearly Repeat Customers
Challenge No. 636: Find the unique repeat customers in a year.
Solved using: Python.
Compare Unique Array Elements
Challenge No. 634: Starting the week on a comfortable note.
Solved using: R.
Top Three Sales by Date
Challenge No. 624: Find the top 3 highest sales made on a date and list along with Customer Name and Date.
Solved using: Python in Excel.
Rank Cities by Percent Change
Challenge No. 615: List the top 3 cities where sum of %change from 2020 to 2021 and 2021 to 2022 is the highest.
Solved using: Python.
Match Names with Same Initials
Challenge No. 612: List the names if first character of first name and first character of last name are same.
Solved using: Python.
Merge and Sort Name Rows
Challenge No. 606: Merge rows on the basis of names.
Solved using: Python.
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.