title: How to "filter" some values in Excel but to always have consistent number of rows as an output
body: <p>What I would like to find out is how can I achieve that by filtering some values (in my case from <strong>Column F</strong>) for some instances to show me whole range of rows and not only matched rows? In my case that is consecutive 6 rows always (from Row 2 to 7, and then Row 8 to 13 etc..) it doesnt matter if they are emtpy or full, I just need them to be shown on filter and rest &quot;hidden&quot;. Also, it might be possible to be more than one match, like in Excel Tables Filter, but for certain number of rows.
  <strong><strong>A<strong>s you can see it is combination of empty rows and visible rows.</strong></strong></strong>
  Open for all solutions, VBA also.</p>
  <p><a href="https://i.stack.imgur.com/oLIhr.gif" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oLIhr.gif" alt="Examples" /></a></p>
  <p><strong>This is what is expected when I filter out other values..?!</strong>
  <a href="https://i.stack.imgur.com/2ZZfx.gif" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2ZZfx.gif" alt="Ex2" /></a></p>