FILTER: show/don't show selection with tickboxes

[ancharwashere]

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

[Peo Sjoblom]

Have you looked at the custom part of autofilter?

--
Regards,

Peo Sjoblom

(No private emails please)


"ancharwashere" <[email protected]> wrote in message
news:[email protected]...
> 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

[ancharwashere]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>