+ Reply to Thread
Results 1 to 4 of 4

SEARCH ENGINE IN EXCEL: With multiple queries/criterias

  1. #1
    Registered User
    Join Date
    05-15-2013
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2007
    Posts
    2

    Post SEARCH ENGINE IN EXCEL: With multiple queries/criterias

    Good day!

    Hi! I'm Allison and I'm a newbie when it comes to Visual Basics. What I wanted to do was to create something like a search engine that shows the result from the best to the least that matches the certain criteria logged in the program. I hope you can show me how to do and guide me along the way. It would also be very helpful if you could give me the code so I can learn it and I can ask you guys about it. This is just a prototype of what me and my group is doing.

    Please and Thank you!

    The password is "iemploy"

    Sincerely,
    Allison L.

    IEmploy1.xlsx

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: SEARCH ENGINE IN EXCEL: With multiple queries/criterias

    Allison,
    You have attached a sheet with 4 tabs, but we do not know what/where you are searching for. What would be the return once a match is found?
    the best to the least that matches the certain ? what is the best?
    You have left lots of unknown from the attached.
    Please attach with the above your desired result.

  3. #3
    Registered User
    Join Date
    05-15-2013
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: SEARCH ENGINE IN EXCEL: With multiple queries/criterias

    YES that!

    "What would be the return once a match is found?
    the best to the least that matches the certain ? what is the best?"

    This.

    The "Analytics" tab will show the Name and Contact Number that will return the best to the least from the database.

    The best will be the one that matches most of the criteria that changes according to what is logged in the "Home" tab and the least will be the one that matches "School, School code, age, college and course"

    :D Thank you.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: SEARCH ENGINE IN EXCEL: With multiple queries/criterias

    I havnt opened the file, but I think it would helkp if you included a few sample answers of what your expected outcome would be, as well as how you arrived at that?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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