Show rows based on filter

[Astrid123]

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?


[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Fruit[/TD]
[TD]Banana[/TD]
[TD]5 kilos[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]Apples[/TD]
[TD]2 kilos[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Vegetables[/TD]
[TD]Brocoli[/TD]
[TD]1 piece[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD]Corn[/TD]
[TD]3 kilos[/TD]
[/TR]
</tbody>[/TABLE]

 

[Astrid123]

Anyone?

 

[Astrid123]

I will give it one more try.. Anyone who knows a solution?