And a sample of what you might want to use:

=OR(A2={"jim","mary","roger","dan","sue"})

And filter to show the True's.

prakash wrote:

Hi,
I have an excel sheet where there are around 20 names in one column and
various data related to those names in other columns.
I want to view only 5 names and the data related to them in one click.
I have put the autofilter options for those columns, but I can view a
maximum of 2 names (Custom option - equal to). Otherwise I have select each
name once and view the name and their corresponding data in other columns,
which I do not want to do.

Is there a way to select more than 2 (5 in my case) in just one click.

Regards,
Prakash

--

Dave Peterson