You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
-
So apparently, while this filter is great, I've been asked if:
I can provide an average of column a if column b has a y in it.
So far so easy.Yep - averageif or an array formula (see attached).
Then I don't fully follow what you're after. If you can explain / illustrate this:
But, if there's a no, I need to replace the no value with the previous y.
So, if looking at dates from Jan 2015 to march 2016. There's a 3 month period from Jan > > to march 2015 I can't use. So I'd like to replace that with the first 3 months previous.
It sounds like the sort of thing we can formula our way out of
christianSpaceman
@Chalfie
So apparently, while this filter is great, I've been asked if:
I can provide an average of column a if column b has a y in it.
So far so easy.
But, if there's a no, I need to replace the no value with the previous y.
So, if looking at dates from Jan 2015 to march 2016. There's a 3 month period from Jan to march 2015 I can't use. So I'd like to replace that with the first 3 months previous.
How could I do that? Create an autofilter for a larger period of time, then average if y?
This is for the control limits on the chart.
This is a project that I feel I'm having the goalpost moved on me. The dashboard shows the number of things per month. They want upper and lower control limits based on whether the value should be included. If they say no, they want it replaced with the first previous y.
Sorry, I'm off work and it's bugging me.
Ive done everything but this bit. It's really simple to do manually, you'd just look at the sheet and select the data, but automatically with no VBA and no user input is puzzling me. The idea is that users get this sheet, bang numbers into a table, the one bit of VBA does the table for the graph. People rejoice. Etc and so on.
I've got thoughts about offset and stuff.