The autofilter is pretty powerful, and a great tool for non-programmers.
Adding a way to include the autofilter selections in a formula would be
pretty powerful. I find many people in my office use autofilter then add
another column to catagorize the the selected data, if you had a wizard that
allowed you to make multiple case selects and assign a value it would
automate what they currently do manually. The key would be to make it easy
enough for non-programmers to use.

----------------
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...et.f unctions