Need help with counting unique values

I am using Excel 2007

Hi everyone,

So here is my problem I have 50 000+ rows that covers fiscal years from 2006 to 2014 and I want to calculate how many unique clients are there per asset type per fiscal year. In addition, the results table needs to adjust to filters i would use on the raw data..

As:

	2007	2008	2008
Commodity	45
FX
Other
other

Here is a sample file: SampleData.xls