bill wrote:
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.
Hi Bill,
Assuming data in Column A only, fill a column in the second sheet with this
formula:
=INDIRECT("Sheet1.A"&TEXT(ROW()*3;"0"))
Replace "Sheet1.A" with the actual sheet name and column address of you data.
This will return the data from rows 3, 6, 9, etc. If those aren't the correct
rows, you may have to do some math in the ROW()*3 section.
tc
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
