The average of best TWO months ?

[makinmomb]

243,700.00 227,100.00 142,150.00
304,850.00 307,350.00 479,450.00


I have these on c2 d2 and e2 , want formula on g2 to find the average of the best two

Expected result if I manually do is
(243700+227100 ) divide 2
(307350+479450 ) divide 2

[Glenn Kennedy]

Hi. this is one way:

=(LARGE(A1:C1,1)+LARGE(A1:C1,2))/2

[makinmomb]

Nice one
Thanks

[Tony Valko]

Here's another one...

Data Range

	C	D	E	F	G
1
2	243,700.00	227,100.00	142,150.00	------	235,400.00
3	304,850.00	307,350.00	479,450.00	------	393,400.00

This formula entered in G2 and copied down:

=AVERAGE(LARGE(C2:E2,{1,2}))

[makinmomb]

Nice one too Tony

[Tony Valko]

_____