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
Not sure you need VBA (macro) for this, you can probably do it with a table of dates and averageifS()
Upload a small sample workbook, and I will see what we can put together
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Here is a sample
rainfall.xlsx
Thanks again!
Perhaps like this then?
Hi Settler,
A Pivot Table might do exactly what you need without needing any VBA. See the attached.
One test is worth a thousand opinions.
If I understand you correctly...
=AVERAGEIF($A$2:$A$14,1,$B$2:$B$14)
Not sure what you mean by Q1 and Q2 though?
Thanks!!! Solved!
Out of interest, who solved it for you?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks