#1
|
|||
|
|||
Filter or Lookup Formula to Organize Keywords
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? |
#2
|
|||
|
|||
Maybe a single column (and formula) will do?
Code:
=IF( IFERROR(1*(FIND("doctor",$A2)>0),0)+IFERROR(2*(FIND("professor",$A2)>0),0)=0; "", INDEX( {"doctor";"professor";"doctor and professor"}, IFERROR(1*(FIND("doctor",$A2)>0),0)+IFERROR(2*(FIND("professor",$A2)>0),0) ) ) |
#3
|
|||
|
|||
Quote:
|
#4
|
|||
|
|||
What about
|
#5
|
|||
|
|||
The formula returns either "doctor", "professor", or "doctor and professor". You set the autofilter for table on - you always can get a list of entries having "doctor" in them by setting the filter for formula column to "doctor" and "doctor and professor", or a list of entries having "professor" in them by setting the filter for formula column to "professor" and "doctor and professor", etc.
|
#6
|
|||
|
|||
Thanks for this. But, the formula only identifies which cell has the word “doctor” and/or “professor”.
|
#7
|
|||
|
|||
Quote:
|
#8
|
|||
|
|||
Here you have two variants of formula (for the second one I defined a Table and used Table Formula syntax)
|
#9
|
|||
|
|||
Thanks for the Arvi. I checked and it worked to filter those keywords with a "doctor" or "professor" on it. Very helpful of you. Thanks again.
|
Tags |
filter formula, lookup formula |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need help with lookup formula | tristanlau | Excel | 1 | 08-14-2017 07:16 AM |
Formula help please (lookup across multiple sheets) | froggybsb03 | Excel | 2 | 03-16-2017 02:16 AM |
lookup or filter data, update it and save it | fre_ | Excel Programming | 3 | 06-06-2016 08:54 PM |
LOOKUP - Complex lookup with 2 lookups in 1 cell | sglandon | Excel | 6 | 05-05-2016 09:44 AM |
Best way to organize resources | Steve. | Project | 3 | 05-17-2014 07:07 AM |