Hi All,
I have a large budget spreadsheet where i have various codes ranging from A1-A50, however right now I only use about 15 of the codes but the other ones will be eventually populated. The description column uses an index match Formula which looks up a code list. What i want to do is hide any Rows where no value is returned in the Description column. I have tried some code on other forums but it appears that because I have a formula in the description column it doesnt recognise it as blank. This is the formula I use for description =IFERROR(INDEX(tb_Master_table[Sub Category],MATCH(A22,tb_Master_table,0)),"")
So the idea would be that only rows from "code to A4" would be visible. All help greatly appreciated
<tbody>
</tbody>
<tbody>
</tbody>
I have a large budget spreadsheet where i have various codes ranging from A1-A50, however right now I only use about 15 of the codes but the other ones will be eventually populated. The description column uses an index match Formula which looks up a code list. What i want to do is hide any Rows where no value is returned in the Description column. I have tried some code on other forums but it appears that because I have a formula in the description column it doesnt recognise it as blank. This is the formula I use for description =IFERROR(INDEX(tb_Master_table[Sub Category],MATCH(A22,tb_Master_table,0)),"")
So the idea would be that only rows from "code to A4" would be visible. All help greatly appreciated
<tbody>
</tbody>
Code | Description | |
A1 | Accountant Fees | |
A2 | Legal Fees | |
A3 | Rent | |
A4 | Fixtures and fittings | |
A5 | ||
A6 | ||
A7 | ||
A8 | ||
A9 | ||
A10 | ||
A11 | ||
A12 | ||
A13 | ||
A14 |
<tbody>
</tbody>