+ Reply to Thread
Results 1 to 3 of 3

Advanced search formula

  1. #1
    Forum Contributor
    Join Date
    09-16-2013
    Location
    Los Angeles, USA
    MS-Off Ver
    Excel 2011
    Posts
    620

    Advanced search formula

    I would like to further advance some search formulas. I have attached my workbook.
    The Search page allows the user to search all the records on the ReturnData page based on the criteria entered into E1-E7. The search formula is located in the C column on ReturnData, which looks like this:
    Please Login or Register  to view this content.
    and then the results are ranked in the B column:
    Please Login or Register  to view this content.
    Then displayed on the Search page using the following formula:
    Please Login or Register  to view this content.
    How could the formula be written so that if cell B1 on sheet SearchSettings equals 1 then it hides the records from the search results where E equals Lost, but if its 0 then it performs as normal.
    Also if cell B2 on sheet SearchSettings equals 1 then it hides the records from the search results where E equals Damaged, but if its 0 then it performs as normal.
    My plan is to have a userform edit those cells, allowing the user to easily show or hide those records.
    Attached Files Attached Files

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Advanced search formula

    By hide do you mean:
    -hide the entry so the looks blank
    -hide the row(you need VBA)

    You can not hide a row with formula
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  3. #3
    Forum Contributor
    Join Date
    09-16-2013
    Location
    Los Angeles, USA
    MS-Off Ver
    Excel 2011
    Posts
    620

    Re: Advanced search formula

    I would like it so the rows with that criteria (for example E equals Damaged), would not appear in the search results. They can remain on the ReturnData page.
    My thought was if the formula was written to say if B1 = 0 then do this, if it equals 1 to this, and if B2 = 0 do this, if it equals 1 to this. Or something to that effect, and I could then just control the cell values with a userform. Is this possible?

+ 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. Advanced search within a spreadsheet
    By Benwyatt1 in forum Excel General
    Replies: 5
    Last Post: 11-06-2012, 05:24 AM
  2. Advanced Search and Replace
    By hscmsf in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-09-2012, 08:42 PM
  3. advanced search
    By Felixx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2010, 01:09 PM
  4. Advanced Search
    By Talisa in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 10-26-2009, 04:58 PM
  5. advanced search
    By izzo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-31-2006, 12:13 PM

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