Multi-Row Formula

[dreamlaurie]

Can I use the Multi-Row tool to find the next Account with a "0" in Doc 2/Doc 3?  I want to apply some math between Account 123 and Account 999 with the zeros several rows down.

[OTrieger]

@dreamlaurie 
Of course that you can do it. 
There are several options,:
1. you can define the rows +1 +2 +3 +4 etc. or -1 -2 -3 -4 etc.
Or you can filter out the row in between and then do the usual away with +1 or -1

[griffinwelsh]

Not sure if I understand your goal, but this configuration will increase the new field number by 1 each time Doc 2 = 0 or Doc 3 = 0.

[dreamlaurie]

How do I filter out the rows in between?  For each set of data like this, I don't know how many rows will be between the 123 and the 999 with the zeros.  Thanks