| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Limit the number of rows for a filter
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 ? -- guilbj2 ------------------------------------------------------------------------ guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043 View this thread: http://www.excelforum.com/showthread...hreadid=375271 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| Excel filter no longer calculates the number of matches | Excel Discussion (Misc queries) | |||
| flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
| increasing the number of rows of a worksheet beyond 65536? | Excel Discussion (Misc queries) | |||
| Data Filter - Not all rows in spreadsheet will display in Autofilt | Excel Worksheet Functions | |||
Threaded Mode
