LeftyLayns
New Member
- Joined
- Aug 28, 2018
- Messages
- 2
I run a report that has a list of numbers, and only need the numbers below the 0's returned in a column or sheet. Here's what the final product should be:
<tbody>
</tbody>
I have an array formula that omits results already found that looks like this:
=(IFERROR(INDEX($A$2:$A$19,MATCH(0,IF(ISBLANK($A$2:$A$19),1,COUNTIF($C$1,$A$2:$A$19)),0)),""))
and as the fomula is pasted down what is Column C where $C$1 is changed to $C$1:C2 in row 3 to keep continuity and that gets me this formula result:
<tbody>
</tbody>
I just cannot for the life of me figure out how to alter the formula to only target for numbers below the 0's.
Report: | Forumla Result: | |
0 | 0 | |
0 | 8005 | |
8005 | 5364 | |
7163 | 3667 | |
0 | 1971 | |
0 | ||
5364 | ||
4912 | ||
4398 | ||
0 | ||
3667 | ||
2139 | ||
0 | ||
0 | ||
0 | ||
0 | ||
1971 |
<tbody>
</tbody>
I have an array formula that omits results already found that looks like this:
=(IFERROR(INDEX($A$2:$A$19,MATCH(0,IF(ISBLANK($A$2:$A$19),1,COUNTIF($C$1,$A$2:$A$19)),0)),""))
and as the fomula is pasted down what is Column C where $C$1 is changed to $C$1:C2 in row 3 to keep continuity and that gets me this formula result:
Forumla Result: |
0 |
8005 |
7163 |
5364 |
4912 |
4398 |
3667 |
2139 |
1971 |
<tbody>
</tbody>
I just cannot for the life of me figure out how to alter the formula to only target for numbers below the 0's.