deleting cells from a calculation...

  • Thread starter Thread starter ajohns
  • Start date Start date
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
 
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 *
 
Back
Top