Perhaps autofilter on a helper col will be potent enough?
Assume source data in A2 down
Assume your list of words to find is in F2:F5 ie: dog, cat, house, car
Put in B2: =COUNTIF($F$2:$F$5,A2)
Copy down to last row of source data. Col B returns 1 where the source word
in col A is found in your list. Autofilter on col B, choose: 1. You got it.
Aha? Hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"golden" wrote:
Find: dog, cat, house, car,
How do I do this?