rain

Hi all, I've got a file where I have multiple products and they have certain characteristics. These characteristics also have values. I need to lookup which products only have the characteristic value of "rain" or "rain" AND "fire". If a product does not meet this criteria, the lookup should...

Hello, Newbie here, I am trying to create a spreadsheet, and I have it setup for the most part, but needing some help. The 12, 24 & 36 Mo. tabs work the same. The only difference is the size of the Gray Table. In the link, there is a downloadable version of the workbook...

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...

Hi all! i have to convert rain per minut to rain per hour in Excel. I have date, time and rain for the respective minut. I can convert it to rain per day, but i would like to make a function, which calculates rain pr hour. So if i have a rain that lasts 3,5 hours, i get 4 cells. So is there a...