Hi All,

I have a data in following order

Column A...........Column B..........Column C
x Com.................10$................1.1.2012
y Com.................37$................2.2.2012
x Com.................20$................5.2.2012
z Com.................43$................10.3.2013 and so on
Y Com................12$
x Com.................22$
y Com.................123$
z Com.................24$

Column A shows the company names there lots of them (over 300) and Column B shows the individual sales amounts for each transaction. Column C is the date of the transaction covering 3 years or more.

In a separate report I am trying to show top 10 companies by sales $s depending on a year selected by user (lets say 2012 is selected)

My problem is I cannot rank company names for the top 10. It needs to be a formula as this will be a dynamic report. Formula should get the total for each company for the selected year (which I can write this with SUMIFS function) and then return the name of the company with the highest sales for 2012 (selected year). then 2nd row 2nd highest and so on.

Heelllppp?

Thanks in advance.

Egemen