Hello,

I have an excel spreadsheet with a column with values like

200
200
200 ==> 3
401
401
401 ==> 3
449
449
449
449 ==> 4
500
500 
500 ==> 3

I would like to have a total for each values displayed... which function should be used ?

I have been using an advanced filter but I need a function to extract the unique values:

Then I used =COUNTIF(K:K,Q2) to count them but I need it to do it in another spreadsheet?

Thanks,

You should add namerange. Ant on advanced filter use it to export data.

Take look on this:

Thanks for this excellent answer it workslike a charm 

Happy New Year

Dom