Excel 2000 issue.

J

James

Hi,
I wanted help on this issue....
I have a list of items in an excel sheet with their
descriptions adjacent to them...

Ex:
xyz abcd efg hijfkk kjkksg xyz

Here xyz is in one cell and its description in the next
cell that's from abcd to xyz.
I have a list of these items.
There are two specific words in the second cell i.e.
description cell. I want to filter out the items and
description from all the cells where these two words are
found in the description field.

Please help me with this issue.
Thanks
 
D

Dave Peterson

I'd use 3 helper columns.

In the first helper column (say C)
=ISNUMBER(SEARCH("efg",B1))

in the second helper column (say D)
=ISNUMBER(SEARCH("jfk",B1))

in the third helper column:
=AND(C1,D1)

Then Data|filter|autofilter for just TRUE in that third helper column.

===
You could actually combine all 3 into 1:
=AND(ISNUMBER(SEARCH("efg",B1)),ISNUMBER(SEARCH("jfk",B1)))
 
Top