This video demonstrates the use of the DISTINCTCOUNT function in Excel's PowerPivot Add-in.
------------------------