View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default Average of top 3 numbers.

Are you using a different delimiter, if you are from Scandinavia (I noticed
a Swedish word there) there the delimiters are ; and not , so it would look
like

=MEDEL(STÖRSTA(E6:W6;{1\2\3}))


--

Regards,

Peo Sjoblom



"Belzbub" wrote in message
...
Sorry was a bit early. When i mark the whole area i get FALSE.


Everything is numbers yes.