Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Eliminating every 25th row
I have a work sheet that contains a daily summary of hourly data in every 25th row. I wish to perform calculations on the 24 rows of hourly data in between the daily data in every 25th row. How do I eliminate every 25th row. Or can I somehow check the value of the "hour" cell which equals 25 for the daily data and use that value to cause the row to be hidden? -- Lram ------------------------------------------------------------------------ Lram's Profile: http://www.excelforum.com/member.php...nfo&userid=238 View this thread: http://www.excelforum.com/showthread...hreadid=476501 |
#2
|
|||
|
|||
Why not work on element 24+25* i ?
"Lram" wrote in message ... I have a work sheet that contains a daily summary of hourly data in every 25th row. I wish to perform calculations on the 24 rows of hourly data in between the daily data in every 25th row. How do I eliminate every 25th row. Or can I somehow check the value of the "hour" cell which equals 25 for the daily data and use that value to cause the row to be hidden? -- Lram ------------------------------------------------------------------------ Lram's Profile: http://www.excelforum.com/member.php...nfo&userid=238 View this thread: http://www.excelforum.com/showthread...hreadid=476501 |
#3
|
|||
|
|||
On Sat, 15 Oct 2005 11:04:11 -0500, Lram
wrote: I have a work sheet that contains a daily summary of hourly data in every 25th row. I wish to perform calculations on the 24 rows of hourly data in between the daily data in every 25th row. How do I eliminate every 25th row. Or can I somehow check the value of the "hour" cell which equals 25 for the daily data and use that value to cause the row to be hidden? If all the 25th rows have some characteristic that is unique to summary rows, then you could filter the data to show only the summary rows, then delete all those rows. If there's no unique character then you could put =IF(MOD(ROW()-n,25)=0,"Summary","Data") where n = your first data row, against the first data row and copy down, now filter on the word "Summary" and delete the visible rows. HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#4
|
|||
|
|||
Eliminating every 25th row
If you just want to sum them, use a formula like
=SUMPRODUCT(--(MOD(A1:A25,25)<1),A1:A25) adjust the range to suit, and understand that the <1 refers to the first row. If you want to ignore some other in the series, adjust that as well. -- HTH RP (remove nothere from the email address if mailing direct) "Lram" wrote in message ... I have a work sheet that contains a daily summary of hourly data in every 25th row. I wish to perform calculations on the 24 rows of hourly data in between the daily data in every 25th row. How do I eliminate every 25th row. Or can I somehow check the value of the "hour" cell which equals 25 for the daily data and use that value to cause the row to be hidden? -- Lram ------------------------------------------------------------------------ Lram's Profile: http://www.excelforum.com/member.php...nfo&userid=238 View this thread: http://www.excelforum.com/showthread...hreadid=476501 |
#5
|
|||
|
|||
Eliminating every 25th row
Bob,
=SUMPRODUCT(--(MOD(A1:A25,25)<1),A1:A25) Didn't you left some ROW()s out there! ;-) =SUMPRODUCT(--(MOD(ROW(A1:A25),25)<1),A1:A25) Regards, Daniel M. |
#6
|
|||
|
|||
Eliminating every 25th row
I think I just might have :-))
Bob "Daniel.M" wrote in message ... Bob, =SUMPRODUCT(--(MOD(A1:A25,25)<1),A1:A25) Didn't you left some ROW()s out there! ;-) =SUMPRODUCT(--(MOD(ROW(A1:A25),25)<1),A1:A25) Regards, Daniel M. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Eliminating Spaces | Excel Discussion (Misc queries) | |||
eliminating extra rows in spreadsheet | Excel Discussion (Misc queries) | |||
Eliminating data repitition | Excel Discussion (Misc queries) | |||
Eliminating Pivot Table Subtotals | Excel Discussion (Misc queries) | |||
Eliminating "Selects" | Excel Discussion (Misc queries) |