insert a row when theres change in a row.
You may want to add headers, sort your data (if you want) and then use
data|subtotals to get that inserted line.
And you'll end up with counts or sums of anything field you want, too. Along
with the outlining symbols to the left that allow you to hide/show details.
elaine wrote:
Hi all,
Does anyone knows how to insert a row automatically when the value
within a column changes?
Ie. Column A is list of names, sort by A to Z, (where there are values
in other columns too)
So you may have a column looks like:
Amanda
Amanda
Amanda
Becca
Becca
Charlotte
Elle
Elle
Elle etc
Is there a way to automatically insert a row after changes to make the
following:
Amanda
Amanda
Amanda
Becca
Becca
Charlotte
Elle
Elle
Elle
Thanks.
Elaine.
--
Dave Peterson
|