ExcelBanter - Filters

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Filters (https://www.excelbanter.com/excel-discussion-misc-queries/69175-filters.html)

Jerry

Filters

Is there a way to limit the number of items in an autofilter dropdown list?
I am only interested in ascending, descending, top 10 and all. Don't want
the 1000 items that come up causing the ascending descending to disappear to
the top of the list.
--
Jerry

Dave Peterson

Filters

I don't think so.

Jerry wrote:

Is there a way to limit the number of items in an autofilter dropdown list?
I am only interested in ascending, descending, top 10 and all. Don't want
the 1000 items that come up causing the ascending descending to disappear to
the top of the list.
--
Jerry

--

Dave Peterson

All times are GMT +1. The time now is 06:01 AM.