Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keyword search, several keywords
I have a column with a keyword at each row, there are several keywords. Now I want to check, row for row, if any of these keywords occurs in another column. I want this check to be done by using only one column for the calculations. Ex: KEYWORDS test alpha house bike COLUMN A | COLUMN B Row tow bow | FALSE Pest test best | TRUE Alpha beta gamma | TRUE xor or and | FALSE Thanks in advance! -- Doman ------------------------------------------------------------------------ Doman's Profile: http://www.excelforum.com/member.php...o&userid=36271 View this thread: http://www.excelforum.com/showthread...hreadid=564185 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keyword search, several keywords
One way ..
Assuming keywords will be entered within F1:F10 With source data running in A1 down, In B1, copied down: =SUMPRODUCT(ISNUMBER(SEARCH($F$1:$F$10,A1))*($F$1: $F$10<""))0 would return the required results Replace SEARCH with FIND if you need it to be case sensitive. SEARCH is not case sensitive. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Doman" wrote: I have a column with a keyword at each row, there are several keywords. Now I want to check, row for row, if any of these keywords occurs in another column. I want this check to be done by using only one column for the calculations. Ex: KEYWORDS test alpha house bike COLUMN A | COLUMN B Row tow bow | FALSE Pest test best | TRUE Alpha beta gamma | TRUE xor or and | FALSE Thanks in advance! -- Doman ------------------------------------------------------------------------ Doman's Profile: http://www.excelforum.com/member.php...o&userid=36271 View this thread: http://www.excelforum.com/showthread...hreadid=564185 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keyword search | Excel Discussion (Misc queries) | |||
How do I allow visitors to do a keyword search of my database? | Excel Discussion (Misc queries) | |||
search by keyword | Excel Discussion (Misc queries) | |||
FAQ Spreadsheet with search function | Excel Discussion (Misc queries) | |||
can i make a formula to search keywords in a excel workbook? | Excel Worksheet Functions |