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.
I figured that the middle number
LARGE(A1:C1,2) will always be in the equation, so I check it against MAX and MIN to see which is closer.