Challenge No. 530: Find the dates when maximum sales was made for a person and also list the corresponding amount.
Solved using: Python.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Signed Number String Sum
Challenge No. 529: Extract the numbers and sum them along with their signs.
Solved using: Python in Excel.
Fill Blanks with Column Index
Challenge No. 237: Fill in the blanks / nulls with column name_1, 2, 3.
Solved using: Python.
Align Nested Headers
Challenge No. 236: Transpose the data as shown.
Solved using: Python in Excel.
Validate Chessboard Pattern
Challenge No. 525: Determine whether a given chess board is valid or not.
Solved using: Python.
Build Alphabet Staircase
Challenge No. 523: Make the staircase of alphabets.
Solved using: Excel VBA.
Sum of Odd Numbers Sequence
Challenge No. 522: Check if a number can be expressed as a sum of consecutive odd numbers.
Solved using: Python in Excel.
Pair Swipes
Challenge No. 73: Pair the staff Swipes.
Solved using: R.
Repeat Rows Until Next Date
Challenge No. 232: Repeat a row till the next date.
Solved using: Python in Excel.
Align Rowwise Data
Challenge No. 520: Align the data as given in answer expected.
Solved using: Python in Excel.