excel should allow a quick filtered count
 

Rather than requiring a filter for unique records only, there should be an
option that works like Count or Sum. When a section is highlighted on a
worksheet, it would return the number of unique records in the lower right
hand side.

----------------
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...ic.excel.setup