LOOKUP Archives - Page 2 of 8

Add Task Duration to Start

Challenge No. 209: Populate the End dates against all owners in a pivot format as shown.
Solved using: Python.

Challenge No. 478: Merger the tables into a single table.
Solved using: Python.

Challenge No. 476: Divide the Sales from Table1 into Table2 equally over Stores.
Solved using: Python.

Challenge No. 471: Decrypt the Encrypted Text using Keyword Cipher.
Solved using: Python in Excel.

Challenge No. 463: Calculate the inventory at the end of all months of the year.
Solved using: Python in Excel.

Challenge No. 198: Find the running total on the basis of max value for the month.
Solved using: Python.

Challenge No. 438: Now, let’s express the derived values as K, M or G (Kilo, Mega or Giga).
Solved using: Python in Excel.

Challenge No. 186: Merge both the tables.
Solved using: Python in Excel.

Challenge No. 420: For the given color bands in Column E, work out the total resistance.
Solved using: Python in Excel.