Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW TO AVERAGE 6 OUT OF 10 NUMBERS IN A ROW, ALWAYS CHANGING CELL
NEED TO AVERAGE A ROW OF NUMBERS PICKING OUT LOWEST 6?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW TO AVERAGE 6 OUT OF 10 NUMBERS IN A ROW, ALWAYS CHANGING CELL
You can use a formulaic array similar to the following:
=AVERAGE(IF(RANK(A1:A10,A1:A10)4,A1:A10,"")) Make certain you replace A1:A10 with the range of numbers you want to average and press cntrl-shift-enter -- Regards, Eddie http://www.HelpExcel.com "FUNACH" wrote: NEED TO AVERAGE A ROW OF NUMBERS PICKING OUT LOWEST 6? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW TO AVERAGE 6 OUT OF 10 NUMBERS IN A ROW, ALWAYS CHANGING CELL
Try this:
=AVERAGE(SMALL(A1:A10,{1,2,3,4,5,6})) -- Biff Microsoft Excel MVP "FUNACH" wrote in message ... NEED TO AVERAGE A ROW OF NUMBERS PICKING OUT LOWEST 6? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW TO AVERAGE 6 OUT OF 10 NUMBERS IN A ROW, ALWAYS CHANGING CELL
Refer your other post.. Please dont multi-post . Also avoid using caps in
subject.... -- If this post helps click Yes --------------- Jacob Skaria "FUNACH" wrote: NEED TO AVERAGE A ROW OF NUMBERS PICKING OUT LOWEST 6? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW TO AVERAGE 6 OUT OF 10 NUMBERS IN A ROW, ALWAYS CHANGING CELL
If you only have 10 items use the Large function to subtract the 4 largest
Exapmle data in cells A3:J3 =(SUM(A3:J3)-LARGE(A3:J3,1)-LARGE(A3:J3,2)-LARGE(A3:J3,3)-LARGE(A3:J3,4))/6 if the number of cells floats use the Small function to get the six smallest =(SMALL(A3:J3,1)+SMALL(A3:J3,2)+SMALL(A3:J3,3)+SMA LL(A3:J3,4)+SMALL(A3:J3,5)+SMALL(A3:J3,6))/6 -- If this helps, please remember to click yes. "FUNACH" wrote: NEED TO AVERAGE A ROW OF NUMBERS PICKING OUT LOWEST 6? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW TO AVERAGE 6 OUT OF 10 NUMBERS IN A ROW, ALWAYS CHANGING CELL
Array entered: ctrl + shift + enter
=AVERAGE(SMALL(A2:A11,ROW($1:$6))) Regards Robert McCurdy "FUNACH" wrote in message ... NEED TO AVERAGE A ROW OF NUMBERS PICKING OUT LOWEST 6? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
average a continuous group of numbers and negative numbers are 0 | Excel Worksheet Functions | |||
Average of column with changing numbers of records | Excel Discussion (Misc queries) | |||
changing numbers in a text string in a new cell | Excel Discussion (Misc queries) | |||
changing average if cells populated | Excel Worksheet Functions | |||
Way To Copy Formula In Column Without Changing All Cell Numbers | Excel Discussion (Misc queries) |