HELP - NEED FORMULA

Copper 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