Hello,

I cannot figure out how to return the reference to the next visible cell in a column. I have values in column D (D2=292.6, D3=270.57, D4=263.85, D5=263.49...), and would like to return in column H the difference between neighboring columns, so H2=D2-D3. The issue is that rows will be filtered, and I need the equation to only consider visible rows, so if row 3 is filtered, the resulting value in H2 should now be D2-D4.

Thanks