subtotals with custom autofiltering
Hi, and thanks for helping,
I have a large data set, with lots of subtotals. When I customize an autofilter for a particular column (say Weeks on Hand <=4), the subtotal automatically reverts to level 3. When I reset to level 2, the customized autofilter no longer works, and I get all values. What to do? Thanks again, Charlie |
subtotals with custom autofiltering
Not sure that I understand the question. Do you mean that you are using
subtotal function with autofilter? Perhaps you can post the formula for the subtotals and provide a small sample of data for the column to which the filter is applied. If the subtotal is for different column to the one with the filter then a sample of that data also. -- Regards, OssieMac "teh_chucksta" wrote: Hi, and thanks for helping, I have a large data set, with lots of subtotals. When I customize an autofilter for a particular column (say Weeks on Hand <=4), the subtotal automatically reverts to level 3. When I reset to level 2, the customized autofilter no longer works, and I get all values. What to do? Thanks again, Charlie |
All times are GMT +1. The time now is 01:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com