Hi, I have this issue where i have a list of numbers example
429,528,598,643,719,802,864,31743 and I only need to remove the 31743 which is a odd number, and all other numbers are in the required range. I tried TRIMMEAN, but that removes the high and low. which is not right. The right average should be 655 but when you use the TRIMMEAN i get 692.
Actual average 429 to 864
How can i just exclude the high value and not the value on the lower side.