Not showing more than 10000 rows in filtering

Hello and good time to all friends
I have a problem in the Excel file that when I filter a column, it does not show the row data more than 10000.
I also removed the filter for the whole sheet and put it back again. I removed it for one column and put it back again
....
But he did not answer
I think it is the installed Office 2017 (they say that except for the limitations of Excel in this version, but I have another file that has more than 10,000 files and does not have this problem)
Thank you for your guidance

The filter drop-down will only show the 1st 10,000 distinct values.

Originally Posted by habib100

Hello and good time to all friends
I have a problem in the Excel file that when I filter a column, it does not show the row data more than 10000.
I also removed the filter for the whole sheet and put it back again. I removed it for one column and put it back again
....
But he did not answer
I think it is the installed Office 2017 (they say that except for the limitations of Excel in this version, but I have another file that has more than 10,000 files and does not have this problem)
Thank you for your guidance

thank,
But I want this problem to be solved in any way WITH VBA OR....

The drop-down cannot be changed, it's just one of those limitations. You would probably need to create a userform with a combobox to get round the limitation.

Originally Posted by Fluff13

The drop-down cannot be changed, it's just one of those limitations. You would probably need to create a userform with a combobox to get round the limitation.

You can do it for me
؟

Nope, that is not what you asked for.
Maybe somebody else will step in.

Originally Posted by habib100

Hello and good time to all friends
I have a problem in the Excel file that when I filter a column, it does not show the row data more than 10000.
I also removed the filter for the whole sheet and put it back again. I removed it for one column and put it back again
....
But he did not answer
I think it is the installed Office 2017 (they say that except for the limitations of Excel in this version, but I have another file that has more than 10,000 files and does not have this problem)
Thank you for your guidance

But I want this problem to be solved in any way
WITH VBA OR MACRO ....

Then you should have said that at the start.

Originally Posted by Fluff13

Then you should have said that at the start.

I thought it would be solved with commands and settings...

Unfortunately not. Just be patient & hopefully another member will step in & help.

Originally Posted by Glenn Kennedy

Moved to VBA sub-forum.

hello ok
thank

Originally Posted by habib100

But I want this problem to be solved in any way
WITH VBA OR MACRO ....

hello
No one has a solution؟

One workaround is to group the first 10,000 rows.

You can use instead:
1. Advanced Filter (without vba)
or
2. SQL (with vba)

thank
If possible, I want to do it with VBA

Originally Posted by josephteh

One workaround is to group the first 10,000 rows.

thank
If possible, I want to do it with VBA

Originally Posted by mjr veverka

Macro for your minimalist example for the Advanced Filter:

Please Login or Register  to view this content.

HELLO
THANKS
The file I sent is a part of the relevant file
When I insert the code into the file it doesn't work!
I want column C and column I to have the ability to filter more than 10,000 rows

Originally Posted by mjr veverka

Macro for your minimalist example for the Advanced Filter:

Please Login or Register  to view this content.

hello
When I insert the code into the file it doesn't work!.....

Originally Posted by habib100

... it doesn't work!

... any code applied to the wrong file will not work
... any code applied to invalid data (to wrong data type) in the file will also not work

... but try this below:

- ">99", ">A100" see:
https://support.microsoft.com/en-us/...8-3f16abdff32b
"0" - for "Unique" option in 'Advanced Filter'

Please Login or Register  to view this content.

With the type of data you included in the new file, it is unlikely that the macro for the advanced filter will work properly.



ps:
Your file seems to be corrupt, it doesn't respond to many simple sheet operations.

Originally Posted by mjr veverka

... any code applied to the wrong file will not work
... any code applied to invalid data (to wrong data type) in the file will also not work

... but try this below:

- ">99", ">A100" see:
https://support.microsoft.com/en-us/...8-3f16abdff32b
"0" - for "Unique" option in 'Advanced Filter'

Please Login or Register  to view this content.

With the type of data you included in the new file, it is unlikely that the macro for the advanced filter will work properly.



ps:
Your file seems to be corrupt, it doesn't respond to many simple sheet operations.

hello
When I insert the code into the file it doesn't work!.....

Originally Posted by habib100

hello
When I insert the code into the file it doesn't work!.....

hello
No one has a solution؟

Correct the line

Please Login or Register  to view this content.

on two lines:

Please Login or Register  to view this content.

Artik

Originally Posted by Artik

Correct the line

Please Login or Register  to view this content.

on two lines:

Please Login or Register  to view this content.

Artik

hello . thanhs
but When I insert the code into the file it doesn't work!.....

Originally Posted by habib100

hello . thanhs
but When I insert the code into the file it doesn't work!.....

No one has a solution؟[/QUOTE]

hello . thanhs
I want column C and column I to have the ability to filter more than 10,000 rows
but When I insert the code into the file it doesn't work!.....