Challenge No. 684: Align Name and amounts together as shown.
Solved using: R.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Grid Lookup By Pattern
Challenge No. 683: Find the value corresponding to numbers given in column N from the grid given of left hand side.
Solved using: Python.
Split And Align Columns
Challenge No. 681: Split and align the data as shown.
Solved using: Python in Excel.
Last Selected Queue Item
Challenge No. 679: For production runs, number of items (say N) to be selected in one go is given in every column.
Solved using: Python.
Quarterly Payment Grouping
Challenge No. 676: Today’s challenge is contributed by 🇰🇷 Taeyong Shin
Divide the payments among different quarters / months.
Solved using: R.
Draw Star Shape Pattern
Challenge No. 673: Create the star patterns for given N.
Solved using: R.
Calculate Level Hierarchy Totals
Challenge No. 672: Level 1 is sum of Level 2.
Solved using: R.
Draw Alphabet Z Pattern
Challenge No. 668: Create alphabetic Z for N values as shown.
Solved using: Python.
Fill Missing With Average
Challenge No. 666: Fill in the blanks with (Total – Sum of non Blanks Values)/Number of Blanks
Hence for row 3: (580-(170+150))/1 = 260
For row 7: (440-90)/2 = 175
For row 9: (360-0)/3 = 120.
Solved using: Python.
Pivot Hierarchical Sublevels
Challenge No. 663: Pivot the data as shown.
Solved using: Power Query.