Challenge No. 322: Find the top 3 employees whose salary is nearest to average salary.
Solved using: DAX.
⭐️ Beginner
Easy challenges for newcomers.
Find the Sum of the Series
Challenge No. 318: Find the Sum of the Series – 1*2*3 + 2*3*4 + 3*4*5+.
Solved using: DAX.
Swap first and last letters unless vowels
Challenge No. 317: Swap the first and last letter of each words in given names.
Solved using: DAX.
Matrix Calculation! Part 1
Challenge No. 188: Create a formula that, for any given value of ‘n’, generates an ‘n x n’ identity matrix where all values are 0, except for the diagonal (primary) values, which should be 1.
Solved using:Excel (IF, LAMBDA, LET), Google Sheets, Power Query (List.Transform), Python, and Python in Excel.
Find the first 20 EVEN Fibonacci numbers
Challenge No. 316: A Fibonacci number is a sum of previous two terms starting with 0 & 1.
Solved using: Excel VBA.
Remove letters in Planets column from Author Column
Challenge No. 315: Remove the English letters appearing in Planets column from Author Column.
Solved using: Python in Excel.
Find texts that are ATBASH Palindromes
Challenge No. 314: ATBASH Palindrome – In ATBASH cipher, we replace a with z, b with y, c with x.
Solved using: Python in Excel.
Generate the result table with Tn = T(n-2) & Tn
Challenge No. 313: Generate the result table.
Solved using: Python in Excel.
List all Sumproduct numbers
Challenge No. 312: List all Sumproduct numbers from column A.
Solved using: Python in Excel.
Extracting Whole Route
Challenge No. 53: Generate a whole route for the airlines
e.
Solved using: R.