Challenge No. 431: Rank regions on the basis of values given for each year and list the regions for maximum occurrences of Rank 1, 2 and 3 in different years.
Solved using: Python in Excel.
Indexing & Ranking
Creating indexed/ranked lists in datasets.
Slice Numbers with Greater Rules
Challenge No. 384: Take position 1 in given number as first slice (I am following index 1 notation of Excel not index 0) and cut the slice starting from position 2 in such a way that the slice is > previous slice.
Solved using: Python in Excel.
Find Word by Exact Index
Challenge No. 367: Capture the word starting at given index.
Solved using: Python.
First and Last Duplicates
Challenge No. 143: List those rows for employees where first and last duplicate values occur for a value.
Solved using: Python in Excel.
Reverse Words Between Indexes
Challenge No. 351: Reverse the words between two words whose both inclusive positions are given.
Solved using: Python in Excel.
Calculate check digit using Damm algorithm
Challenge No. 338: Calculate check digit using Damm algorithm.
Solved using: Python in Excel.
Index by Department or Mail
Challenge No. 118: Assign Index starting with 1.
Solved using: Python in Excel.
Add Index Column! Part 6
Challenge No. 182: In the question table, assign an index to the blank cells, starting from 1.
Solved using:Excel (IF, LAMBDA, LET), Google Sheets, Power Query (List.Combine, List.Split, List.Transform), Python, Python in Excel, and R.
Rank by Best of 3 Subjects
Challenge No. 106: Generate the result table from problem table.
Solved using: Power Query.
Add Hierarchical Location Indexes
Challenge No. 88: Add the indexes for Country, State and City.
Solved using: Python in Excel.