Say you had the following list of 10 numbers:

439.0
446.0
435.5
435.0
441.0
444.5
449.5
444.5
447.5
440.0

You wish to average the list excluding the two highest and two lowest values (average the 6 median values).

That I can do. However, I need to do this MANY times over on multiple worksheets in multiple files and would like to avoid doing it by hand each time. Also, the values need to remain in their original order on screen.

I was thinking some method of sort, select, average, unsort. Started to make a macro using filter->sort, but dont have that option since Im on 2002 Pro.

Any ideas?

Thank you,
Brian