Good day. I have a datasheet that has addresses (eg. 10023) and a set of row number values in columns beside each address across a range (eg. 10023 occurs eight times with these row numbers 3, 12, 13, 15, 18, 20, 22, 23). I would like the vba for a trimmean that for each address finds all those row numbers, sort them from least to most, trim off outlier data (eg. removes 12.5% of bottom and top values, for 10023 would be 3 and 23) and then find the average of the remaining data (eg. for 10023 would be 23.33), and to do thid across a unique list of the addresses. Attached is a sample file showing the intended outcome Sample data sheet for the Trimmean vba