Refer next value in array in excel formula

microsoft-excel

How about just offsetting the arrays:

=INDEX(I22:M22<>0,)<>INDEX(J22:N22<>0,)

This finds where a value is <>0 but the one after it =0, or vice versa

<edit: and enter with Ctrl+Shift+Enter />

Related

dd without any options
Is it possible for me to create a Windows bootable USB flash drive using Linux running on a Raspberry Pi?
What is the best way to backup an SSH key in case my hard drive fails, etc?
Gremlin in W7 SP1
Preventing windows 10 quick access from pinning folders under certain folder
X-Ray computed tomography
Find out the values for which the function is continuous [duplicate]
Ultrafilters and self-injections
Find the marginal densities of $X$ and $Y$ knowing $h(x,y)$
Subdirect embedding of a quotient algebra
Density of a quotient. Let $A,B\overset{\tt iid}{\sim} \mathcal{N}(0,1)$, $X=ae^A$ and $Y=be^B$. What is the density of $Z=X/Y$?
Show that if $R^n$ has an eigenvector basis for a matrix A, then there exists an eigenvector basis with respect to the transpose of A