So basically I have a 96 well plate (rows A-H, columns 1-12). I do
duplicate samples (2 wells per sample). The problem is that the layout
of my plate is not always the same. Sometimes I have samples in B1:B2
and sometimes there may be controls there. Basically I am hoping there
is a way to tell excel, if I have the formula, to use sample 1 data
(whatever cells I tell excel they are in) to calculate what I need. It
would be easy to set up if my plate always had the same layout, but
that isn't always the case. So essentially I am looking for a way to
tell excel that 2 to n data points are from sample one and to calculate
an average from those 2 to n data points.

Die_Another_Day wrote:
I have no idea what you are asking, but it sounds simple if I can
figure out what you want to do...

Charles

wrote:
I had one more quick question, so if I were to put in the data in an
array format (8x8, 9x9, etc.) is there any way that I would be able to
highlight the cells that correspond to compound 1 (say cells 1-4),
compound 2 (5-8), etc. and have the macro calculate averages based on
this? Sometimes my data will get up to 12x12 and writing a repetitive
if...then statement covering sample numbers ranging from 1-48 would be
really tedious. Not sure if there is a way that the you can denote
cells on a template lets say and have excel use the corresponding cells
for calculations.