Challenge No. 497: For given range A2:A100, populate 1, 2, 3.
Solved using: Python in Excel.
⭐️ Beginner
Easy challenges for newcomers.
Show Transposed Amount Values
Challenge No. 216: Transpose the table as shown.
Solved using: Excel VBA.
Date Cipher Decryption
Challenge No. 492: DATE CIPHER DECRYPTER – Decrypt the given messages which were encrypted using following logic.
Solved using: Python in Excel.
Sort Zoo Records Alphabetically
Challenge No. 214: Align the data as per Zoo and sort them alphabetically.
Solved using: DAX.
Max Frequency Characters
Challenge No. 487: Find the characters whose frequency is the maximum and also find the maximum frequency.
Solved using: Excel VBA.
Convert List to Integer Intervals
Challenge No. 486: Generate the integer intervals corresponding to given numbers.
Solved using: Python in Excel.
Score Matrix for Team Matches
Challenge No. 482: Prepare the given matrix from problem table.
Solved using: Python in Excel.
Insert Group Name
Challenge No. 66: Group the staff and insert the group name after the last count.
Solved using: Python.
Triangular Record Grouping
Challenge No. 477: Align the data as shown which is 1 record, then 2 records, then 3 records and so on.
Solved using: Python in Excel.
Summarize Yearly Sales
Challenge No. 207: Generate the result table from problem table.
Solved using: Python in Excel.