If you are not familiar with Excel's Auto-Filter feature, it is pretty handy. Even if you are familiar with this feature, you may not be familiar with the combination of subtotal() and Auto-Filter. This short 90 second video demonstrates.
This video explains Excel's Auto-Filter feature, and then shows you how to combine it with the subtotal() function for some very cool functionality.