Filtering question

  • Thread starter Thread starter richzip
  • Start date Start date
R

richzip

Is there a way to expand the filter option so that it shows 1 row (or more),
both above and below any row that contains the value I am looking for?
 
Data|filter|autofilter examines each cell/row on its own.

Maybe you can put the key value for each group on the rows you want. Then
filter by that column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using AutoFilter from VBA 1
questions on advanced filter 4
Auto filter for multiple columns 2
AutoFilter column w/merged cells 2
Filtering with SUMIFS 1
make filter permanent 2
Count all except filtered data 2
Macro - hide rows that are 0 without an auto-filter 3

Back
Top