Challenge No. 239: Transpose the problem table into result table and calculate the drop in sales amount from one quarter to previous quarter.
Solved using: Python.
Indexing & Ranking
Creating indexed/ranked lists in datasets.
Index-wise Base Encoding Sort
Challenge No. 527: Convert every digit from right to left in the base of its index + 1 reading index 1, 2.
Solved using: Python.
Rank by Student Grade
Challenge No. 518: Rank the students on the basis of grades.
Solved using: Python.
Hierarchical Project Indexing
Challenge No. 221: Do the Indexing for project, task and activity.
Solved using: Python.
Index Range Closest to 100
Challenge No. 493: List the Start and End Indexes where sum of numbers <=100 with minimum gap between sum of numbers and 100. Solved using: R.
Rank by Demand
Challenge No. 64: Rank the Fruits Based on Demand
e.
Solved using: Python.
Rank Sales with Tie Handling
Challenge No. 450: Assign rank on the basis of sales made by different salespersons in a company.
Solved using: Excel VBA.
Top 3 Closest City Pairs
Challenge No. 446: The distance between two cities is given in the grid.
Solved using: R.
Encrypt Using Columnar Cipher
Challenge No. 442: Columnar Transposition Cipher
Write the keyword in a row
Rank the letters of keyword as per their position in English language in descending order.
Solved using: Python in Excel.
Generate Employee Group Index
Challenge No. 185: For each group, generate the index.
Solved using: Excel VBA.