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