auto filter 1

[Chrissirhc]

Hi,

How do I give a range of criteria in my custom auto filter?

e.g. Bring back all the results that have Chris, John, Lee, Adrian in this column?

Thanks,

Chris

 

[SkipVought]

Hi,

Either use Advanced Filter, where there can be more than TWO criteria or construce a helper column with a formula that returns one value for any of those occurrences.

Skip,

_{[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen!}