+ Reply to Thread
Results 1 to 2 of 2

Get desired text across filter limitation

  1. #1
    Forum Contributor PRADEEPB270's Avatar
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2010
    Posts
    280

    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
    Regards


    Pradeep Kumar Gupta
    Gurgaon ( INDIA )

  2. #2
    Forum Expert
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,206

    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)

Bookmarks

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