Excel 2000 issue.

  • Thread starter Thread starter James
  • Start date Start date
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
 
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)))
 
Back
Top