Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Average of ...
Anyone know how to pick out the highest 4 cells of 6 cells and then calcukate
the average the 4 cells. tnx |
#2
|
|||
|
|||
Hi Tudor
=SUM(LARGE(B2:B7,{1,2,3,4})) where your range is B2:B7 is the range containing your 6 cells. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Tudor" wrote in message ... Anyone know how to pick out the highest 4 cells of 6 cells and then calcukate the average the 4 cells. tnx |
#3
|
|||
|
|||
Hi Julie,
I think you mean =AVERAGE(LARGE(B2:B7,{1,2,3,4})) Bob "JulieD" wrote in message ... Hi Tudor =SUM(LARGE(B2:B7,{1,2,3,4})) where your range is B2:B7 is the range containing your 6 cells. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ...well i'm working on it anyway "Tudor" wrote in message ... Anyone know how to pick out the highest 4 cells of 6 cells and then calcukate the average the 4 cells. tnx |
#4
|
|||
|
|||
Hi tnx but I 'm not sure I understand you. What do you mean with the
,{1,2,3,4} ? "JulieD" skrev: Hi Tudor =SUM(LARGE(B2:B7,{1,2,3,4})) where your range is B2:B7 is the range containing your 6 cells. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Tudor" wrote in message ... Anyone know how to pick out the highest 4 cells of 6 cells and then calcukate the average the 4 cells. tnx |
#5
|
|||
|
|||
Aha now I understand. Allmost. But when I use:
=ADD.IF(C6:I6;"LARGE(C5:G5;2)") it will not work. Maybe I need to convert the LARGE(C5:G5;2) to a string. ? It is working when I use =ADD.IF(C6:I6;"2") Tudor "JulieD" skrev: Hi Tudor =SUM(LARGE(B2:B7,{1,2,3,4})) where your range is B2:B7 is the range containing your 6 cells. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Tudor" wrote in message ... Anyone know how to pick out the highest 4 cells of 6 cells and then calcukate the average the 4 cells. tnx |
#6
|
|||
|
|||
I think I got it now. I will try to implement it in the real sheet on monday.
Maybe I ask you guys again if something comes up. One problem is that I use a swedish Excel and it diffecult to find the right function when translating it from english. Tnx TUDOR "Tudor" skrev: Anyone know how to pick out the highest 4 cells of 6 cells and then calcukate the average the 4 cells. tnx |
#7
|
|||
|
|||
Hi
this seems to be a different question, what are you trying to achieve with this formula? =ADD.IF(C6:I6;"LARGE(C5:G5;2)") -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Tudor" wrote in message ... Aha now I understand. Allmost. But when I use: =ADD.IF(C6:I6;"LARGE(C5:G5;2)") it will not work. Maybe I need to convert the LARGE(C5:G5;2) to a string. ? It is working when I use =ADD.IF(C6:I6;"2") Tudor "JulieD" skrev: Hi Tudor =SUM(LARGE(B2:B7,{1,2,3,4})) where your range is B2:B7 is the range containing your 6 cells. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Tudor" wrote in message ... Anyone know how to pick out the highest 4 cells of 6 cells and then calcukate the average the 4 cells. tnx |
#8
|
|||
|
|||
let us know how you go and feel free to ask any additional questions you
have ... -- Cheers JulieD "Tudor" wrote in message ... I think I got it now. I will try to implement it in the real sheet on monday. Maybe I ask you guys again if something comes up. One problem is that I use a swedish Excel and it diffecult to find the right function when translating it from english. Tnx TUDOR "Tudor" skrev: Anyone know how to pick out the highest 4 cells of 6 cells and then calcukate the average the 4 cells. tnx |
#9
|
|||
|
|||
Hi Bob
thanks ... ! -- Cheers JulieD "Bob Phillips" wrote in message ... Hi Julie, I think you mean =AVERAGE(LARGE(B2:B7,{1,2,3,4})) Bob "JulieD" wrote in message ... Hi Tudor =SUM(LARGE(B2:B7,{1,2,3,4})) where your range is B2:B7 is the range containing your 6 cells. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ...well i'm working on it anyway "Tudor" wrote in message ... Anyone know how to pick out the highest 4 cells of 6 cells and then calcukate the average the 4 cells. tnx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average the Last Five Cells in a Column | Excel Worksheet Functions | |||
Plotting moving average line on a chart | Charts and Charting in Excel | |||
Complex Average | Excel Worksheet Functions | |||
Average | Excel Worksheet Functions | |||
average, array and offsets | Excel Worksheet Functions |