I would like assistance with a formula to accomplish the following:
From a row of data I would like to generate a second row that contains 20
nonzero cells from the original row of data beginning with the cell working
from right to left. Note: I will be adding data to the original row and would
like the formula to regenerate a new row considering the new data and
dropping off data that is more than 20 nonzero cells to the right of the last
entry.