+ Reply to Thread
Results 1 to 15 of 15

Search Limitation

  1. #1
    Forum Contributor
    Join Date
    10-08-2013
    Location
    End of the World, USA
    MS-Off Ver
    EXCEL 2007
    Posts
    111

    Search Limitation

    I have a sheet with 30 reports. I need to find the one called "APPL" at the beginning but only the one that has the cell "iTap" in an area one to three rows below it in some column. I want to select what is one cell below "iTap".

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Search Limitation

    Please Login or Register  to view this content.
    Last edited by ragulduy; 11-12-2013 at 11:59 AM.

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Search Limitation

    Maybe:

    Please Login or Register  to view this content.

  4. #4
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Search Limitation

    @John,

    Need to search the entire column for itap and that will exit the loop after the first APPL. I think you need:
    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Search Limitation

    @yudlugar - Thanks for the insight, but I wasn't sure if there would be more than one "APPL".

    "I need to find the one called "APPL" at the beginning". BTW your code is much more efficient.

  6. #6
    Forum Contributor
    Join Date
    10-08-2013
    Location
    End of the World, USA
    MS-Off Ver
    EXCEL 2007
    Posts
    111

    Re: Search Limitation

    Can I also find the report with both APPL and iTap and search for "Daily Excess"? between that first APPL with iTap found and the next occurence of APPL?
    Last edited by frank35; 11-14-2013 at 09:24 AM.

  7. #7
    Forum Contributor
    Join Date
    10-08-2013
    Location
    End of the World, USA
    MS-Off Ver
    EXCEL 2007
    Posts
    111

    Re: Search Limitation

    anything on this?

  8. #8
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Search Limitation

    Can you attach a file with some sample data to view? To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

  9. #9
    Forum Contributor
    Join Date
    10-08-2013
    Location
    End of the World, USA
    MS-Off Ver
    EXCEL 2007
    Posts
    111

    Re: Search Limitation EXAMPLE

    ( many similar reports)
    find APPL and iTap within 5 rows from each other and find the next report called APPL iFlat report. Within that range find "LABEL TO FIND" (then go one below to get the example 1,000,000.00

    report APPL report report report report report report
    report report report report NOTiTap report report report
    report report report report report report report report
    report report report report report report report report
    report report report report LABEL TO FIND report report
    report report report report 9,999,999.99 report report

    report APPL report report report report report report
    report report report report iTap report report report <-- APPL iTap reports start here, search from here
    report report report report report report report report
    report report report report report report report report
    report report report report report report report report
    report report report report report report report report

    report APPL report report report report report report
    report report report report iTap report report report
    report report report report report report report report
    report report report report report report report report
    report report report report LABEL TO FIND report report
    report report report report 1,000,000.00 report report <-- I want to find this number within the APPL iTap reports

    report APPL report report report report report report
    report report report report NOTiTap report report report
    report report report report report report report report
    report report report report report report report report
    report report report report report report report report
    report report report report 9,999,999.99 report report

    report APPL report report report report report report <-- search ends here
    report report report report iFlat report report report
    report report report report report report report report
    report report report report report report report report
    report report report report report report report report
    report report report report report report report report

    (similar reports with APPL and others and iTap and others at beginning of reports)

  10. #10
    Forum Contributor
    Join Date
    10-08-2013
    Location
    End of the World, USA
    MS-Off Ver
    EXCEL 2007
    Posts
    111

    Re: Search Limitation

    so basically what you did before but times two and then a third search between the rows found by the two searches.

  11. #11
    Forum Contributor
    Join Date
    10-08-2013
    Location
    End of the World, USA
    MS-Off Ver
    EXCEL 2007
    Posts
    111

    Re: Search Limitation

    anything on this?

  12. #12
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Search Limitation

    What do you want to do with the information once found?

  13. #13
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Search Limitation

    This will find the second instance and highlight?

    Please Login or Register  to view this content.

  14. #14
    Forum Contributor
    Join Date
    10-08-2013
    Location
    End of the World, USA
    MS-Off Ver
    EXCEL 2007
    Posts
    111

    Re: Search Limitation

    this helps to find it in the example but not in the actual document, as it is always structured differently, look at the additional comments please.

  15. #15
    Forum Contributor
    Join Date
    10-08-2013
    Location
    End of the World, USA
    MS-Off Ver
    EXCEL 2007
    Posts
    111

    Re: Search Limitation

    Let me explain in another way: I need:

    In an Excel 07 ninja-report (very long) the following is needed to create a limited search
    Search where ABC and 100 are in any cell within 2 rows from each other
    Search where ZZZ and 100 are in any cell within 2 rows from each other
    Search for Gold to find the value in the cell to the right of it but in the range of the previous two searches' rows.

+ 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. Using IF with more than 7 limitation
    By MrStang in forum Excel General
    Replies: 6
    Last Post: 02-27-2009, 09:19 AM
  2. [SOLVED] Row Limitation
    By Atom Smasher in forum Excel General
    Replies: 4
    Last Post: 07-17-2006, 03:05 PM
  3. [SOLVED] Way around row limitation
    By mrwawa in forum Excel General
    Replies: 4
    Last Post: 06-29-2006, 03:50 PM
  4. printing limitation
    By ar8824 in forum Excel General
    Replies: 1
    Last Post: 10-06-2005, 03:05 PM
  5. [SOLVED] Excel Limitation
    By Farhan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-11-2005, 05:06 AM

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