To Find an item from list items automatically.
I have a list items more than 10000, is it possible to get items name from the list if we enter first 3 -4 letters of the item.
If i enter an item first 3 - 4 letters in a cell, i want to get all the items starting with those 3- 4 letters.
For Eg:- if i enter PANA in a specified Cell, it should show all the item which contains PANA.
Like Panadol Active
Panadol Cold & Flue
Hi mohamedcv,
Welcome to the board.
Some sample of what I interpret your request to be.
With the search string in D1 enter in B2 this formula copied down as far as needed.Formula:
Please Login or Register to view this content.
Then in D2 this formula filled down until you get blanks.Formula:Please Login or Register to view this content.
Row\Col pana PanadolAlabama PanadolAlabama Alaska PanaCalifornia Arizona PanamaDelaware Arkansas PanaCalifornia Colorado Connecticut PanamaDelaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota
Last edited by FlameRetired; 12-20-2015 at 02:02 AM.
Dave
Thank you every much
What follows is a generic approach...
In C1 control+shift+enter, not just enter:
=SUM(IF(ISNUMBER(SEARCH("|"&D1,"|"&$A$2:$A$24)),1))
In D2 control+shift+enter, not just enter, and copy down:
=IF(ROWS($D$2:D2)<=$C$1,INDEX($A$2:$A$24,SMALL(IF(ISNUMBER(SEARCH("|"&$D$1,"|"&$A$2:$A$24)),ROW($A$2:$A$24)-ROW($A$2)+1),ROWS($D$2:D2))),"")
You are welcome. Thank you for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks