Want a percentages of a single cell divided by a column of cells
You need to make the cell reference for the second cell absolute - you
use the dollar symbol $ for this, for example:
=A2/A$1
When you copy this down it will become:
=A3/A$1
=A4/A$1
etc.
Hope this helps.
Pete
dbog wrote:
Want the symbol to make the formula repeat in each new cell, but keep the
second cell the same. Thought it was a karat, but that doesn't work.
|