Auto filter & statistics

  • Thread starter Thread starter OscarC
  • Start date Start date
O

OscarC

Hello,

A query:

I have a list of sample names in column A e.g. Sample A, Sample B
Sample C etc. In column B I have data relating to these sample point
in column B. The data fills down several hundred rows.

Is it possible to create a formula which will calculate the mean when
have autofiltered column A for one of the sample points? ie a cel
would have the formula to calculate the mean depending upon what dat
is displayed by the autofilter.

I know I could move the data into different columns and calculate th
mean, but for the purpose of my spreadsheet it is not possible.

thanks

Michae
 
Back
Top