Lynne,

Check out Data/Filter/Advanced - it can do exactly what you want.

"LynneS" wrote:

I have a 10+ column, 10000+ rows. Some clients are repeating due to separate
auto, umbrella, home policies, etc. In column heading COV, I would like to
pull all clients with "AUT" AND "HOM".