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
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)
[/IMG]
thanks a lot for the help ^^
warm regards
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
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)
![2vjsear.jpg](/board/proxy.php?image=http%3A%2F%2F%5BIMG%5Dhttp%3A%2F%2Fi65.tinypic.com%2F2vjsear.jpg&hash=2551321c7ef7bd9dc7a516529f7563b0)
thanks a lot for the help ^^
warm regards