As usual, Im having a hard time developing a complicated formula. @Paul Newcome helped me last time with a great solution. Im hoping someone can help untangle the webs for me.
I have a sheet that has (among other things) a Date column, another column with a formula that determines a number of days, and a month number helper column.
What I need to do is to count the 9th column and break it into 2 buckets (columns) per month on another sheet.
The other sheet will look similar to this:
Month Bucket1 (if number is 1-10) Bucket2 (if number if 11+)
Jan X X
Feb X X
Mar X X
Im trying to figure out how to fill in the numbers for each bucket.
