I need to use IF function with conditions: 1) to multiply the number by the serial row with the last number of the date column. 2) to continue the process, with next batch of numbers, with similar criteria 3) to ignore the second last serial column (serial), before the date column data (left to right)
Solved by I. J. in 18 mins