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

"prakash" ha scritto nel messaggio
...
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.



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

Maybe it's time to learn about data|filter|Advanced filter.

Debra Dalgleish has some notes:
http://www.contextures.com/xladvfilter01.html
http://www.contextures.com/xladvfilter02.html

You could also cheat.

Set up another column that contains a formula that evaluates to true or false
based on your criteria--then filter by that column.

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

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

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

Regards,
Prakash

"Dave Peterson" wrote:

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