Home

HELP - NEED FORMULA

%3CLINGO-SUB%20id%3D%22lingo-sub-894029%22%20slang%3D%22en-US%22%3EHELP%20-%20NEED%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-894029%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20sure%20this%20is%20a%20simple%20formula%20but%20I%20can't%20figure%20it%20out!%26nbsp%3B%20I%20want%20to%20get%20the%20average%20of%20the%20two%20highest%20values%20only%20in%20the%20column%20of%20values.%26nbsp%3B%20THANK%20YOU%3C%2FP%3E%3CP%3E0.009%3CBR%20%2F%3E%3CSTRONG%3E0.040%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E0.052%3C%2FSTRONG%3E%3CBR%20%2F%3E0.007%3CBR%20%2F%3E0.007%3C%2FP%3E%3CP%3E%3D%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-894029%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-894053%22%20slang%3D%22en-US%22%3ERe%3A%20HELP%20-%20NEED%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-894053%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F249970%22%20target%3D%22_blank%22%3E%40NRC_CO5280%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DAVERAGE(LARGE(A%3AA%2C%7B1%2C2%7D))%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-909156%22%20slang%3D%22en-US%22%3ERe%3A%20HELP%20-%20NEED%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-909156%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20worked%20thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-909291%22%20slang%3D%22en-US%22%3ERe%3A%20HELP%20-%20NEED%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-909291%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F249970%22%20target%3D%22_blank%22%3E%40NRC_CO5280%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
NRC_CO5280
New Contributor

I'm sure this is a simple formula but I can't figure it out!  I want to get the average of the two highest values only in the column of values.  THANK YOU

0.009
0.040
0.052
0.007
0.007

3 Replies

@NRC_CO5280 

That could be

=AVERAGE(LARGE(A:A,{1,2}))

@Sergei Baklan 

 

It worked thanks!

@NRC_CO5280 , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies