Hi, I am looking to create an average or trimmean formula that allows me to average the bottom 95% of my values. The values being turnaround time in days for often greater than 500 items.
The number of values I look at from month to month changes but i want the formula to ignore the top 5% while generating the average and be able to account for the change in item count.
To add to this I also need it to only calculate the average for those values only when it meets a criteria of "Y".
I should also mention I would like to accomplish this without using a Pivot.
Can anyone help with this or is this too complex for excel.
Bookmarks