Filter the entries of one column

[GN0001]

Hello team,

I am going to filter the entries of a column. I don't want to go by unselecting all the entries and then going through the filter and select those ones which I need.

I can type in the name in the search box of a filter. then I select the first entries in the list.

Now, how can I add other entries ,without going through the list, to first entries?

I appreciate your help.

Thanks,
GN0001

 

[Nebu]

Hi;

Use wildcards in your search.

Thanks

 

[GN0001]

Hi;

Use wildcards in your search.

Thanks

If I need only George, Brenda, James and Ely to be selected, how can I proceed?
Regards,
GN0001

 

[Nebu]

Hi:

Use the advanced filter !!

Here is a link which will help you understand more on advanced filter.
http://www.excel-easy.com/examples/advanced-filter.html

Thanks

 

[GN0001]

Hi:

Use the advanced filter !!

Here is a link which will help you understand more on advanced filter.
http://www.excel-easy.com/examples/advanced-filter.html

Thanks

Hello Nebu,
Thanks for the answer, I want to select several items in a pivot table filter. Advance filter becomes inactive/ dim when I click on one of the cells in Pivot table.

Thanks for the answer.
GN0001

 

[Nebu]

Hi:

Is there a logic behind the names you are filtering for, something in common? Or is it just random names. Could you share a sample workbook and explain what kind of filtering you want to do. My first hunch is that you may need a macro to do this.

Thansk

 

[GN0001]

Hi:

Is there a logic behind the names you are filtering for, something in common? Or is it just random names. Could you share a sample workbook and explain what kind of filtering you want to do. My first hunch is that you may need a macro to do this.

Thansk

The names are random and I come back to you with a sample book. Thanks GN0001