Hello all,
I have a question Ive been trying to figure out for a long time now. Unfortunately I didnt succeed, hopefully you can help me.
The situation is:
In column A I have merged cells, in column B and C just text and at row 1 I applied the standard filter of Excel. What I want is: if I select Banana in column B row 1 by using the filter, Excel to show row 2 and 3, and to hide row 4 and 5. Is there a way to make this possible?
<tbody>
</tbody>
I have a question Ive been trying to figure out for a long time now. Unfortunately I didnt succeed, hopefully you can help me.
The situation is:
In column A I have merged cells, in column B and C just text and at row 1 I applied the standard filter of Excel. What I want is: if I select Banana in column B row 1 by using the filter, Excel to show row 2 and 3, and to hide row 4 and 5. Is there a way to make this possible?
| 1 | Column A | Column B | Column C |
| 2 | Fruit | Banana | 5 kilos |
| 3 | Apples | 2 kilos | |
| 4 | Vegetables | Brocoli | 1 piece |
| 5 | Corn | 3 kilos |
<tbody>
</tbody>
