Hi,

I need to create a custom function similar to TRIMMEAN, but instead of
computing an average, it will compute a standard deviation. You pass it a
range, and a "percent" value to ignore at either end of the range.

I'll list the steps the function needs to perform:

1. Sort the passed range
2. Remove the lowest "percent" cells, and the highest "percent" cells from
the population.
3. Compute the STDEV on the remaining cells.

Questions:

How can I modify the range (i.e. sort it, remove cells, etc,) without
modifying the actual cells?
I could create an array from the range and modify that, but I think I still
need to convert it back to a range to use the STDEV function...

Any tips?

Thanks,
Norvin