Oct 04 2019 10:42 AM
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.0090.0400.0520.0070.007
=
Oct 04 2019 10:49 AM
@NRC_CO5280
That could be
=AVERAGE(LARGE(A:A,{1,2}))
Oct 11 2019 09:02 AM
@Sergei Baklan
It worked thanks!
Oct 11 2019 09:59 AM
@NRC_CO5280 , you are welcome