Filter or Lookup Keywords in Separate Columns
I am coming up with a simple keyword distinguishing two categories of keywords for me to present to my client. Can anyone help me the formula to come up with just the keyword lists containing “Doctor” in the Doctor column and “Professor” in the Professor column? Does this involve a complex formula? See attached worksheet for reference.
Last edited by MKTGCLOUD; 11-26-2018 at 03:47 AM. Reason: Attached worksheet
To get somebody able to help you is try upload your sample excel file with detail explanation about the desired results, how to do that? Click on "Go Advanced" button then scroll down to find "Manage Attachments" text button then upload your file.
Thank you
Azumi
I see. OK I have it attached. Thanks for the assist.
Maybe put this on C2 and ENRED as ARRAY formula then copied down
=IFERROR(INDEX($A$2:$A$612,SMALL(IF(ISNUMBER(SEARCH(C$1,$A$2:$A$612)),ROW($A$2:$A$612)-ROW($A$2)+1),ROWS($A$1:A1))),"")
Or, using AGGREGATE, a normal formula:
=IFERROR(INDEX($A:$A,AGGREGATE(15,6,ROW($A$2:$A$612)/(ISNUMBER(SEARCH(E$1,$A$2:$A$612))),ROWS(E$2:E2))),"")
copy/pasted into E and then down.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Wow. This works.
I checked on your formula, and it does work similarly with that Azumi. Big thanks for your help to the both of you.
Yes this works on both MS Excel and Google Spreadsheets (Note: Aggregate Function is not available in Google Sheets). Many thanks for this.Originally Posted by azumi
Last edited by MKTGCLOUD; 11-27-2018 at 01:45 AM. Reason: Update
I checked your formula too, and it does work similarly with that Azumi. Big thanks for your help to the both of you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks