Forum Discussion
Solved
How do I get the Total Sales data to match the latest monthly sales data available in each row?
Hello everyone, I would like the last column below (Total Sales $) to match the latest monthly sales data for each row, ignoring the purchase qty column information (Example: Jan Pur Qty, Feb Pu...
Use HSTACK:
=XLOOKUP(1, (HSTACK(N4, P4, R4, T4, V4) <> "") * (HSTACK(N4, P4, R4, T4, V4) <> 0), HSTACK(N4, P4, R4, T4, V4), , , -1)
365 variant with data in Table1
=TAKE( TOCOL( WRAPROWS(Table1[@[Dec Pur Qty]:[Mar Sales $]], 2), 1), -1)
