Calculate the average and remove outliers

I blogged before about averaging the top 3 numbers in a list by using the formula =Int(Average(Large(F4:O4,{1,2,3}))) << entered as an array.  Today I was asked how to average a set of test scores, whilst also...

More

A visit from Boudicca

Sometimes you just come across an idea that make you go “Doh! – what a great resource / idea / thing” – I had that experience recently when a colleague handed me a flyer...

More