Auto filter

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,



I have a file, where there are datas in 18000 rows. I am trying to do auto filter but it is not working properly. it is not taking the last few datas?

Can I pls know the reason?

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
too vague not clear. do you use macro or spreadsheet solution. post a small extract of the data and explain what you have done and what is the problem.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
There might be blank lines in between. Before applying or turning on the filter, select all the cells and then turn on the filter