FILTER: show/don't show selection with tickboxes
 

when getting the dropdown menu from filter I sometimes would like to make
more than one selection or even exclude just one kind. I thought this could
be achieved with tickboxes in front of the found strings. e.g:
yes/no blanks
yes/no 1
yes/no 2
yes/no 3
if no selections are made just clicking the selected string would suffice
but if they are an enter should be made.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Have you looked at the custom part of autofilter?

--
Regards,

Peo Sjoblom

(No private emails please)


"ancharwashere" wrote in message
...
when getting the dropdown menu from filter I sometimes would like to make
more than one selection or even exclude just one kind. I thought this
could
be achieved with tickboxes in front of the found strings. e.g:
yes/no blanks
yes/no 1
yes/no 2
yes/no 3
if no selections are made just clicking the selected string would suffice
but if they are an enter should be made.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Yes, that custom thing is quite powerful but I use the equals X OR equals Y
so often I thought it would be neat. Thanks.

"Peo Sjoblom" wrote:

Have you looked at the custom part of autofilter?

--
Regards,

Peo Sjoblom

(No private emails please)


"ancharwashere" wrote in message
...
when getting the dropdown menu from filter I sometimes would like to make
more than one selection or even exclude just one kind. I thought this
could
be achieved with tickboxes in front of the found strings. e.g:
yes/no blanks
yes/no 1
yes/no 2
yes/no 3
if no selections are made just clicking the selected string would suffice
but if they are an enter should be made.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc