how do I average the "n" largest numbers in a column
M Max Sep 21, 2008 #2 cookie said: how do I average the "n" largest numbers in a column Click to expand... 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 ---
cookie said: how do I average the "n" largest numbers in a column Click to expand... 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 ---
