Hi,

Am Wed, 12 Aug 2015 13:30:41 -0700 (PDT) schrieb
:

I have a full sheet which contains a lot of raw data. It will not however go beyond 500 x 500 cells so I use the range "A1:SF500" as a range named All.

I am trying to get the top ten values, numerical only, there are some text values (only "prog" and "autre") but I do not want them to count (as they will come back pretty often.

So my data is in a sheet called "Raw Data" and I want the top ten will be in an other sheet named "Stats Data" in the range "J42:J51".

you can filter by TopTen and count the entries with SOUS.TOTAL
Or look for the function GRANDE.VALEUR


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional