How are you getting your data - from a platereader? Is there anything in
the datafile which maps to specific well contents ?

What format is the file - linear or matrix ? It's sometimes easier to
design anround the raw data format...
And it sounds like your plate layout is not fixed either (12 x 12 ?)

Tim


wrote in message
ups.com...
Each sample will be in at least 2 wells (up to 12 wells per sample
though) and there will only be one sample per well. The reason I need
something that will allow me to specify which wells have which sample
is because there can be anywhere from 2-12 wells per sample. And yes,
there will always be controls somewhere in the data. But each well
will only contain a single sample or a single control.
NickHK wrote:
Charles,
Let me know if I'm on the right track.

So each sample
- takes up 2 wells
- can contain multiple compounds

And there will (probably) be duplicates in the compounds used among all
the
samples.

And a well may contain a control instead of a sample

NickHK

wrote in message
ups.com...
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.