Hello,

Is there some sort of function, or combination of, to do the following. I would have a data set with both positive and negative numbers. I would like to average only the positive, and also have it automatically omit the largest number(s). And vice-versa.

I know there is TRIMMEAN for the entire data set, which omits both lowest and highest. But for this I would only want to take the positive or negative and omit the same.


Hope I explained properly.
Thanks!