Hello all,

I have two columns of data. The first is corresponding to the day of the month (1-30) and the second the corresponding rainfall. I would like to find the average rainfall and Q1 and Q3 for every 1st day of the month, 2nd, etc...

Is there a way for a macro to recognize the number in the cell of the first column and then compute the values for all my data (approximately 5000 points) not in order and not the same amount for all days.

Thanks