• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Why filter drop down limit only 10,000?

Prathamesh

New Member
In excel, why filter drill down limit only 10,000? how can i see more than 10000 unique numbers in Drop down list?
 

Prathamesh

New Member
Agree... But just want to know is thr is wayout? Any other excel format where it shows more than 10,000? Especially when thr is huge data to work on...
 

vletm

Excel Ninja
Prathamesh
Fill manually that You needed value and after that check, if is it possible/valid number.
Even 'drop down' won't be useful everywhere.
... as well as - if You have to 'go' from country to other country ... many times, it won't be useful to walk ...
 

Prathamesh

New Member
Prathamesh
Fill manually that You needed value and after that check, if is it possible/valid number.
Even 'drop down' won't be useful everywhere.
... as well as - if You have to 'go' from country to other country ... many times, it won't be useful to walk ...
Ok dear. Thank you.
 
Top