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?