Remove Unused Cells in Arrayformula

user_14915635 0
Viewed 36

I'm usually pretty good about modifying the arrayformula so that cells aren't displaying values when there is no data adjacent to it. But, with these money values, I can't seem to change it to work. How can the arrayformula be changed so that $0.00 doesn't appear all the way down the column for data that is not yet present?

Here's the spreadsheet to edit. Arrayformula is in yellow highlighted cell.

Thanks for your help!

array-formulas google-sheets
1 Answers

One solution is you can expand the computation to:

=ARRAYFORMULA(IFERROR(1/(1/(DMAX(TRANSPOSE(A3:G), SEQUENCE(ROWS(A3:G)), {IF(,,);IF(,,)}))),""))

The formula will originally return an error for zero result, but because of the IFERROR it will be replaced by space.

enter image description here

user_146060490
Related