| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Counting Rainfall Data
I know this has probably been discussed many times...but I need some
help counting rainfall data. My spreadsheet consists of 50,000+ days worth of rainfall data and I need to know the maximum number of consecutive days with no rainfall OR trace rainfall. For example...my data looks like this from left to right... 0.00 0.00 T 0.15 T T 0.00 0.00 0.27 In this case it would be 4 (T,T,0,0) Can anyone help?? Thanks in advance... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
Threaded Mode
