Formula for this?

[Dark Horse]

I have a 2 column list of 6 times and the distances they were run over; I
want to discard both the fastest and the slowest across the two columns and
produce an average of the remainder.
Example:
Column A Column B
-0.59 sec 5
1.27 sec 8
2.98 sec 6
-.09 sec 12
3.56 sec 7
2.16 sec 10

I would discard entries 1 and 5 to leave:
Column A Column B
1.27 sec 8
2.98 sec 6
-.09 sec 12
2.16 sec 10

giving totals of 6.32 divided by 4 entries = 1.58 and 36 divided by 4
entries = 9
Finally 1.58 divided by 9 would give me the number I want, which is 0.1755.

I am aware that it is not exactly world class mathematics, and that I'm just
looking to make my life easy by automating a simple process - but can a
formula be written in once cell to do what I want?

 

[Aladin Akyurek]

Let A1:B7 house the sample you provided (note the labels and the absence of
"sec" in the A-range)...

{"Time (Secs)","Distance";-0.59,5;1.27,8;2.98,6;-0.09,12;3.56,7;2.16,10}

Try:

=TRIMMEAN(A2:A7,2/COUNT(A2:A7))/TRIMMEAN(B2:B7,2/COUNT(B2:B7))

Caveat. The records should not contain pairs like <Value,Blank> or
<Blank,Value>.

BTW, your hand-computed result is wrong.