Joe Conner wrote:
bill wrote:
My spreadsheet has blood pressure values in sets of 3. I average
each them and then use the average of each set, which works fine.
But, I now have 2 rows that have the original data and nothing else,
and distract from the presentation.
So, I need to either copy every 3rd row to a new sheet or
automagically make the other 2 rows disappear from the original sheet.
I could do it manually, but I get new data frequently and would
prefer not to do all the work by hand.
Is there a way to tell calc to copy just every 3rd row from one sheet
to another, or
to hide 2 of 3 rows ?
Perhaps if you put your raw data on one sheet and your averaged data
on a second sheet?
Good idea, but that still leaves the problem of moving every 3rd row to
the new sheet with the averaged data.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Bill Drescher
william {at} TechServSys {dot} com
