+ Reply to Thread
Results 1 to 2 of 2

Get desired text across filter limitation

  1. #1
    Forum Contributor PRADEEPB270's Avatar
    Join Date
    MS-Off Ver

    Get desired text across filter limitation

    Please consider my attachment.

    I have a file with 20500 rows.Now I want search a word,e.g."Mirror".But through filter it is not possible to find all Mirror in one shot.The error is appearing that more than 10000 unique items.

    Is there any solution through Excel or in VBA world ?
    Attached Files Attached Files

    Pradeep Kumar Gupta
    Gurgaon ( INDIA )

  2. #2
    Forum Expert
    Join Date
    MS-Off Ver

    Re: Get desired text across filter limitation

    You say "get" the text, do you mean to simply display the filtered result in place including all variations or is it ok to take the results and place them on another sheet?

    I am not 100% sure, but I think the 10k limit applies to autofilter only, not advanced filter, so you may want to try that.

    If autofilter cannot do it Then what I would do is load the range into an array or dictionary, loop the array (or column of the arrya) wildcarded for "mirror", and either strip out the non matching from via the loop or dump only the matching via the loop into either a new array and then a new range or straight to a new range
    Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.

    "I am here to help, not do it for people" -Me

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Programmatic Filter not producing desired result set
    By mayoorsubbu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-19-2017, 08:36 AM
  2. Advanced Filter to show desired text or numbers typed in a search box
    By GabrielAlin in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-24-2015, 01:04 AM
  3. Replies: 10
    Last Post: 09-18-2014, 09:36 AM
  4. [SOLVED] Help ~ how to filter two desired words in a cell
    By clifford_ayala in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-28-2014, 08:06 AM
  5. [SOLVED] there is any limitation for text field when using ADO +SQL
    By dj100 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-09-2005, 01:05 PM
  6. auto filter limitation??
    By bigjuno in forum Excel General
    Replies: 0
    Last Post: 03-16-2005, 04:25 AM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1