|Subject:||RE: how to highlight changes in my data from one block of cells to ano|
|Posted by:||J Sedoff|
|Date:||Mon, 28 Jul 2008|
I would imagine that this would best be accomplished in Access, rather than
Excel, but if you want to do it in Excel:
I would set this up with a column for each
> 1. Parameters
> 2. Variables
> 3. Results
and maybe the date you ran the experiment? Make sure to have separate
columns for each setting, with a True/False or Yes/No, unless it can only
have one setting among a group, in which case make a "Setting" column and
write the name down.
How are you copying your numbers down? Are you using a macro, or are you
typing in this data?
> Then the next step is to visualize the changes, for example, changing
> one parameter will lead to what changes in results, this is the key
> question I am asking myself.
I would use a PivotTable here so that you can compare several different
results possibly using a PivotChart.
Hope this helps (I'm unfortunately quite vague though)
how to highlight changes in my data from one block of cells to another block of cells? posted by LunaMoon on Sun, 27 Jul 2008