Formula on a4 b4 and c4 to drag down
Should work on 7500 rows of sheet1
The feed will be b1 the keyword , meaning if I type ARIZONA ,
it should pull all codes with the word Arizona anywhere on the
description
The expected answer for if I type QUARRY should be
Please Login or Register to view this content.
Use this array formula A4 on sheet 2.
pull formula across and down.
=IFERROR(INDEX(Sheet1!A:A,SMALL(IF(ISNUMBER(SEARCH($B$1,Sheet1!$B$2:$B$21)),ROW(Sheet1!$A$2:$A$21)),ROWS(A$1:A1))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Last edited by AlKey; 12-14-2014 at 01:43 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you very much ALKEY,
I edit the formula for 7500 rows and works
very clean , something to be happy about
is its not slow at all
It not case sensitive too , I had one version of the same that only worked on
CAPITAL words
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks