removing extraneous data

[bennyE]

Hello all,

First time post and I'm quite stuck. I have a long table of raw rainfall data at 5 min intervals for a whole year (over 41,000 rows) most rows contain a 0, but I cant simply remove all 0's (that's too easy). I must remove any data where less than 1.2mm of rain falls in a 6h period.

My current thought is to take a sum of all rain fall in the previous 6h and have excel delete any row where the total is less than 1.2. but this still removed data I need.

Anything will help at this point.

I can add an example table if needed but it is quite long (6h of 5 min increments = 72 rows)

 

[Rick Rothstein]

Re: removing extranious data

I can add an example table if needed but it is quite long (6h of 5 min increments = 72 rows)

I think it would be useful to see, but you cannot post it here, rather, post it to DropBox, set it to be shared and then post the link to the file here. Also, describe what data that you needed was deleted when you tried adding the prior 6 hours (remember, we know nothing about your data or your needs, so you have to explain things in detail to us so we can know what you know).

 

[XlsXprt]

Hi Benny,
Without having any of your data, I tried to recreate the scenario. This formula in column D will add up the rainfall data from the 3 hours before and 3 hours after, and if it is greater than or equal to 1.2 mm, then it displays. Hope this helps!

=IF(SUM(C106:C177)>=1.2,SUM(C106:C177),"")