HI
I need some help here
I need to search the keyword for articles, and it will return the name of the articles as a result.
here I attach the file as a reference. I have been using many excel formula but still fail.
thank you for any help or suggestion.
In H4 Cell - Array Formula - Requires Ctrl+Shift+Enter
Formula:
Please Login or Register to view this content.
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
hi sixthsense,
thank you for your quick response. you solve my problem!
I have no issue when I enter the other keywords, but when I key in the keyword "Sebelum" the name of title do not appear
and just one "0" appear in H4 cell. Can you tell me why it happen like that? did I do something wrong?
and hope to get some explanation from you about the formula because sometimes I could not understand excel help.
Sorry because I am not so good in using excel formula.
again, thank you for your help!
Hello,
The reason is that, if you look up the keyword "Sebelum" in the list of keywords, you will see the cell next to it is Empty, thus returning the value "0"
You can try this Array formula
When you enter it, hold Ctrl-Shift and hit Enter
Please Login or Register to view this content.
Now you can type in any word that you think will be in a name of an article, you don't have to specifically choose a word in your keywords list.
See the sample attached
Hope this help.
Edit: You will have to type in the exact word with upcase and lowcase letter, like entering "Tip" and "tip" will return different results ... This is inconvenient ...
Edit 2: All credit goes to Sixthsense for pointing out that when I used SEARCH instead of FIND, it ignores case sensitivity. I have changed the attached file and the formula above.
Last edited by Lemice; 04-21-2013 at 07:23 AM.
(copy pasta from Ford)
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
Regards,
Lem
hi lemice,
thank you for the solution.
it solve my problem
thanks for Sixthsense too
just asking, what is the function of "+1" and "-3"?
Not sure what you meant, the "+1" and "-3" belong to "ROW($D$3:$D$733)-ROW($D$3)+1" and "ROW()-3" respectively, and they belong to parts of 2 smaller formula - The first one being IF and the second one being SMALL. You can think of it as changing value depending on the results / the row which the formula is in.
Alright, thank you for both of you. I manage to solve the problem in 2 days only.
Hope to ask for your help again next time.
thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks