I am trying to use sumproduct with arrays of different size. I want to use last number of smaller array to multiply with remaining values of the large array. For example,
Array 1 = {1,3,5,7,9}
Array 2 = {1,2,3}
I am looking for a formula for expanding the Array 2 to make it {1,2,3,3,3} -- where the last two 3s in this array is the last number of Array 2. Then, I want to make sure that it expand to make this of size of Array 1 so that I can use this for sumproduct.
Any help will be greatly appreciated
Bookmarks