ExcelBanter - Filter

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

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

- - Filter (https://www.excelbanter.com/excel-discussion-misc-queries/247655-filter.html)

John

Filter

Is there a limit to what can be filtered? I have a worksheet that contains
about 30,000 lines, and I just noticed that the last two lines I entered are
not on the fileter.

Gary''s Student

Filter

1. remove the filter
2. select ALL the cells in the column to which you want the filter applied
3. re-assert the filter
--
Gary''s Student - gsnu200908

"John" wrote:

Is there a limit to what can be filtered? I have a worksheet that contains
about 30,000 lines, and I just noticed that the last two lines I entered are
not on the fileter.

John

Filter

Still Didn't work

"Gary''s Student" wrote:

1. remove the filter
2. select ALL the cells in the column to which you want the filter applied
3. re-assert the filter
--
Gary''s Student - gsnu200908

"John" wrote:

Is there a limit to what can be filtered? I have a worksheet that contains
about 30,000 lines, and I just noticed that the last two lines I entered are
not on the fileter.

All times are GMT +1. The time now is 08:46 AM.