I don’t know how to comment on Chandoo’s site, so I’ll post it here.
I have data in three columns: A,B,C and I want to get the average of the closest two values out of three in each row. Could you help me with a formula for this?
Here’s my contribution. A bit long.
=IF(ABS(LARGE(A1:C1,2)-MAX(A1:C1))<abs (LARGE(A1:C1,2)-MIN(A1:C1)),AVERAGE(LARGE(A1:C1,2),MAX(A1:C1)),AVERAGE(LARGE(A1:C1,2),MIN(A1:C1)))
I figured [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2011/01/19/formula-challenge-3/
Posted
Jan 19 2011, 09:37 AM
by
Daily Dose of Excel