Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get the filter results to show up in the status bar? | Excel Discussion (Misc queries) | |||
How do I show number of records that meet criteria filter | Excel Discussion (Misc queries) | |||
How do I show the results of filter? | Excel Discussion (Misc queries) | |||
Show weighted average value after filter. | Excel Worksheet Functions | |||
Why does my advance filter only show one record? | Excel Discussion (Misc queries) |