Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
An eqation to add the largest 6 (or N) numbers from a list
I am trying to get an average of list, but if there are more than 6 numbers
in the list to only use the top 6 values. My first thought was some sort of sum of top six then a count of numbers from the list (in case there are not 6 numbers in the list). Any help is appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling the largest numbers | Excel Worksheet Functions | |||
Highlighting the 5 Largest Numbers in a list | Excel Discussion (Misc queries) | |||
3 largest numbers | Excel Discussion (Misc queries) | |||
return largest number of a list of numbers in the same cell | Excel Worksheet Functions | |||
average of kth largest numbers in an array of n numbers | Excel Worksheet Functions |