"cookie" wrote:
how do I average the "n" largest numbers in a column
Eg in B1: =AVERAGE(LARGE(A1:A5,{1,2,3}))
for the 3 largest numbers in A1:A5
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,000 Files:359 Subscribers:56
xdemechanik
---