Limit the number of rows for a filter

G

guilbj2

I'm filtering data in two columns c5:c3 and d5:d31. It's essentially a
managers name and language code. The idea is to filter stats for a
particular team or language. I've got my formulas working properly,
but I've got some totals in rows b33:i33 through b38:i38 that I want to
remain in place when I filter. I've tried auto filters, but they kill
all the data that I want to remain static. Is there any way I can
filter these columns (I only know autofilter right now) but get it to
only filter information through row 31 ?
 
S

swatsp0p

Try placing a blank row above row 38 and exclude that area from your
autofilter area by highlighting your columns of data in rows 5:36 and
then applying the filter.

HTH
 
S

swatsp0p

I'm glad it worked for you. Thanks for the feedback, it is always
appreciated.

Cheers!
 

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

Are Date filters available for items in the Filter area of pivot t 2
is there a limit to the number of rows the filter can handle? 2
How do I create a new worksheet for a subset of data 2
Defining a block of consecutive rows in a datatable 8
How do I force Excel to show filter totals in the Status bar? 2
Macro help! Selecting rows after running a filter 1
How do I limit the number of rows displayed on a worksheet? 4
Macro for counting the number of filtered rows 4

Top