Hi,
Can someone please advise how to proceed?
I have a data base including 3 columns and 22000 rows. In the first column I manually add value=1 for which cells in the second column that is critical and leave the rest of the cells empty.
In another sheet, I need to summarize this data base for another purpose. So only the cells(in the second column) with value 1 is important for me.
If i use "If" formula combined with v lookup, something like +IF(MATRIX!A:A=1,V LOOKUP(MATRIX!B:B, MATRIX!B:E,1,0),) it will still give me the empty cells as well and I will have another file with 22000 rows while I only need the critical ones.
Thoughts?
<tbody>
</tbody>
table above is just a sample, this DB has 22000 rows. So basically I need to only pick up cells in the second column which has value=1 in the first column.
Can someone please advise how to proceed?
I have a data base including 3 columns and 22000 rows. In the first column I manually add value=1 for which cells in the second column that is critical and leave the rest of the cells empty.
In another sheet, I need to summarize this data base for another purpose. So only the cells(in the second column) with value 1 is important for me.
If i use "If" formula combined with v lookup, something like +IF(MATRIX!A:A=1,V LOOKUP(MATRIX!B:B, MATRIX!B:E,1,0),) it will still give me the empty cells as well and I will have another file with 22000 rows while I only need the critical ones.
Thoughts?
<tbody> </tbody> |
<tbody> </tbody> | ||||
1 |
<tbody> </tbody> |
<tbody> </tbody> | |||
1 |
<tbody> </tbody> |
<tbody> </tbody> | |||
1 |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
table above is just a sample, this DB has 22000 rows. So basically I need to only pick up cells in the second column which has value=1 in the first column.