I have a table with month numbers listed vertically and also horizontally on top (1-48 down and 1-48 across).
Month 1 starts in column A, row 1 in cell A1. Formulas spread horizontally to the right only not backwards.
Month 2 starts in column B, row 2 in cell B2.
Formula: IF(B899*'Sync Inv Summary'!$P$13>0,B899*'Sync Inv Summary'!$P$13,"")
Possible formula?: OFFSET($B$1,COLUMNS($B$1:B1)-1,ROWS($B$1:B1)-1,1,1), the syntax (-1, etc.) not correct but does increment?
The goal is to have ONE formula in column A, row 1, cell A1 and have the formula populate the entire table except not in the cells backwards from the starting point of each successive month. In other words, putting the formula in cell A1 and when it fills the table (48 rows, 48 months), cells like in Month 2, cell A2 will never have a value because A2 is in month not Month 2.
Thank you.
Bookmarks