How do I search for keywords in cells containing text?

F

Fredrik

I have a column of cells containing different descriptions. Is there an easy
way to search among these cells for certain keywords?
 
F

Fredrik

I have a list of cars with descriptions, so if I somehow search for 'turbo',
I want the cars with turbo in the description field to appear. Note that the
description cells contain complete sentences, where 'turbo' is only one of
the words.
 
B

Bernie Deitrick

Fredrik,

What is it that you want to do? Know if a keyword is there?

=COUNTIF(A1:A100,"*keyword*")>0
will return TRUE if the keyword is present in any string in A1:A100.

=COUNTIF(A1:A100,"*keyword*")
Will return the number of occurences of keyword

Array entered (enter using Ctrl-Shift-Enter)
=ADDRESS(MIN(IF(ISERROR(FIND("keyword",A1:A100)),1000,ROW(A1:A100))),1)
Will return the address first cell that contains keyword

HTH,
Bernie
MS Excel MVP
 
B

Bernie Deitrick

Select the table, then use Data / Filter / Autofilter. Select the dropdown at the top of the
column, select (Custom...), then look for "Contains" (second last option) and type "Turbo" into the
box, then click OK.

HTH,
Bernie
MS Excel MVP
 
Top