I'm not sure if this is even possible, but I figure it's worth asking.
In the screenshot above, you can see the formula I have. It's working just fine. You'll notice that there are a lot of different criterion in that formula; they are month, day, and time slot (plus an extra one that doesn't really play into this question here).
What I'm wondering is this: is it possible to do this formula for one row and then copy it paste it so that the "day" criteria (which is where it says 'Flare 2Data'!$B$6:$B$262024, "=1") automatically iterates as you drag it down? What I'm having to do now is copy and paste this equation in each cell and manually click on all of them and type in the day. And then I have to do that for every month of the year. Is there a better way?
Aucun commentaire:
Enregistrer un commentaire