Challenge No. 302: Generate Vigenere Cipher Grid.
Solved using: Python.
LET
Assigns names to values or calculations to simplify formulas in Excel.
List the Polydivisible numbers
Challenge No. 301: List the Polydivisible numbers.
Solved using: Python in Excel.
Hierarchical Structure!
Challenge No. 180: In the question table, parents and their children with different IDs are listed.
Solved using:Excel, Google Sheets, Power Query, Python in Excel, and R.
Sort and Position Team Members
Challenge No. 111: Fill in the individuals in Ind columns and their positions in Team Members in Ind_Pos columns.
Solved using: Python in Excel.
Creating a Recruitment Plan from Headcount
Challenge No. 50: Create a Recruitment plan from the Projected Headcount.
Solved using: Python.
Split words by half total alphabet score
Challenge No. 299: Consider a=1..
Solved using: Python in Excel.
Max Call Duration Pair
Challenge No. 298: Work our the pair of persons for whom the sum of call duration is the highest.
Solved using: Python in Excel.
Fill Alphabets in Pattern Columns
Challenge No. 110: Fill in the alphabets from Names column in Name1.
Solved using: Python in Excel.
Evaluate Reverse Polish Notation
Challenge No. 297: Simplified version of Reverse Polish Notation (RPN) – The math operator will come at the end of the Text and you need to evaluate the expression.
Solved using: Python in Excel.
Prime Factors!
Challenge No. 178: Find the prime Factors of numbers in the question table.
Solved using:Excel (IF, LAMBDA, LET), Google Sheets, Power Query (List.Transform), Python, Python in Excel, R, and VBA.