ExcelBanter - Partial average

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Partial average (https://www.excelbanter.com/excel-discussion-misc-queries/203319-partial-average.html)

Partial average

how do I average the "n" largest numbers in a column

Max

Partial average

"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
---

All times are GMT +1. The time now is 11:05 AM.