Frequency of x-day rainfall and annual maximum value of x-day rainfalll

Hi,
I would really appreciate your help. I have a time series of rainfall. I would like to count the annual frequency of 1 day falls, 2 day consecutive falls, 3 day consecutive falls...etc. i.e the number of x day consecutive falls which are preceded by no rain day (RR=0 mm) and followed by a no rain day (RR=0 mm) and find the maximum annual value for each duration (by duration I mean 1 day 2 day 3 day....). I have attached a worksheet as an example where I manually calculated the above for year 1881 and 1882 for 1-day and 2-day durations to illustrate where I highlighted in red the 1 day fall and in yellow the 2 day falls. Thanks in advance.
Regards
alsajim