Results 1 to 4 of 4

Autocomplete search word based on Initial first/random word

Threaded View

  1. #1
    Registered User
    Join Date
    11-12-2015
    Location
    Surabaya, Indonesia
    MS-Off Ver
    MS 365 (Windows 11 64-bit)
    Posts
    84

    Autocomplete search word based on Initial first/random word

    Hi All,

    I've been looking anywhere but I couldn't find the solution, please help. My problem is i want to do autocomplete search based on these condition using function in excel if possible

    1. initial first or random word that contained in the list data.
    2. the search result will be auto sorted from A to Z, not case sensitive, where the first will be the showed result search.

    what i hope is in the attachment or you can see picture below. what'll be the formula?

    so if i type "ij" the result should be Indonesia Jakarta (while 2nd result is Indonesia Jambi)
    if i type "ny" the result should be New York
    if i type "ind" the result should be India New Delhi (because, if it's sorted India New Delhi will be the first to come out)

    P.S the keyword search is not follow some rule, pattern or abbreviated. It'll be completely depend on user, ex : it could be "ijak" to refer to Indonesia Jakarta, etc.

    autocompletesearch.JPG

    thanks a lot for the help ^^
    regards
    Attached Files Attached Files
    Last edited by radian89; 11-12-2015 at 10:42 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 04-29-2014, 10:06 AM
  2. Replies: 2
    Last Post: 08-05-2013, 04:45 PM
  3. autocomplete per word..
    By vijaynadiad in forum Excel General
    Replies: 0
    Last Post: 05-13-2013, 02:30 PM
  4. Replies: 1
    Last Post: 01-25-2011, 10:50 PM
  5. How to search for a word in a column and have entire row opaque once word is found
    By copleyr in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 09-04-2009, 07:11 PM
  6. [SOLVED] search for a specific word and copy the word and the preceeding words until a comma
    By DHANANJAY in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-31-2005, 09:10 AM
  7. Replies: 5
    Last Post: 09-13-2005, 07:06 AM

Tags for this Thread

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