viewing data in autofilter options.

P

prakash

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
 
F

Franz Verga

prakash said:
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.
Click to expand...


Hi Prakash,

You have some different criteria you can use to filter with autofilter...

Try to select "Custom..." or "First 10..." in drop down list of filter.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
D

Dave Peterson

And a sample of what you might want to use:

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

And filter to show the True's.
 
P

prakash

Hi Dave Peterson,
Thanks .
I was able to use this formula and do the filtering.

Regards,
Prakash
 
Top