Hi,
A B C D
Starting Balance 120.00 150.00 200.00
Net Cashflow 0.00 -80.00 500.00
Ending Balance 120.00 30.00 700.00
I know I can get the whole row returned {0.00, -80.00, 500.00} with the following array formula
=INDEX(B1:D3,MATCH("Net Cashflow",$A:$A,0),0)
But how would I get just the non-zero values returned as a row (i.e. Net Cashflow <> 0)?
Further, my end result is the column numbers that contain non-zero numbers for the Net Cashflow row.
Thanks.
A B C D
Starting Balance 120.00 150.00 200.00
Net Cashflow 0.00 -80.00 500.00
Ending Balance 120.00 30.00 700.00
I know I can get the whole row returned {0.00, -80.00, 500.00} with the following array formula
=INDEX(B1:D3,MATCH("Net Cashflow",$A:$A,0),0)
But how would I get just the non-zero values returned as a row (i.e. Net Cashflow <> 0)?
Further, my end result is the column numbers that contain non-zero numbers for the Net Cashflow row.
Thanks.