deleting cells from a calculation...

A

ajohns

Hi

If I had 32 cells, which represented control values, and I wanted to
execute some QC on them if individuals were too far from the mean value,
how could I calculate the average value in one cell and yet exclude
cells where the values were too different?

I hope I have explained this well enough!


If not I will try again following feed back.

Best wishes to you

Andrew J
Scotland
 
A

A.W.J. Ales

Ajohns,

Take a look at the function TRIMMEAN.
(It migth be a function from the Analysis Toolpak)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Top