Hi
I am trying to write a formula that returns the date from a row that corresponds to the first cell in another row that is the first zero. The following example will help explain what I am mean.
<tbody>
</tbody>
The expected results are as follows:
Column 1 - Mar 1
Column 2 - Feb 1
Column 3 - Apr 1
Column 4 - Mar 1
The values in columns 1 to 4 are not blank. There is a formula that returns a calculated value. I only care if the value is zero.
I thought that this match/index formula did the job
=INDEX($A$8:$A$184,MATCH(TRUE,INDEX((C8:C184=0),0,0)))
but it is always returning the last value (Apr 1).
Thanks in advance for your help.
I am trying to write a formula that returns the date from a row that corresponds to the first cell in another row that is the first zero. The following example will help explain what I am mean.
Dates | Column 1 | Column 2 | Column 3 | Column 4 |
Jan 1 | 4 | 1 | 9 | 3 |
Feb 1 | 5 | 0 | 3 | 3 |
Mar 1 | 0 | 0 | 7 | 0 |
Apr 1 | 0 | 0 | 0 | 0 |
<tbody>
</tbody>
The expected results are as follows:
Column 1 - Mar 1
Column 2 - Feb 1
Column 3 - Apr 1
Column 4 - Mar 1
The values in columns 1 to 4 are not blank. There is a formula that returns a calculated value. I only care if the value is zero.
I thought that this match/index formula did the job
=INDEX($A$8:$A$184,MATCH(TRUE,INDEX((C8:C184=0),0,0)))
but it is always returning the last value (Apr 1).
Thanks in advance for your help.