I was provided with an array formula to discard specific values in an average based on the quantity in the sample size. It works very well. Now my boss would like to highlight the values being discarded. I've attached the spreadsheet as it is now and I have manually highlighted the values that are currently being discarded. Please let me know if you need additional information or if you have any questions.
Thanks in advance!
Bookmarks