You are reading a single comment by @Nef and its replies. Click here to read the full conversation.
  • That’s the table, but that’s also reminded me that there are more variables than I thought.

    I’ll have a bit of a dive into MAXIFS and see how I get on. It’s mostly just because there’s only so many times you can manually fill something out before your brain gets annoyed, when you know there must be a way to automate it.

  • Have a stab and I'm sure if you post it up here if it isn't working someone will be able to point you in the right direction.

    That table that Chalfie posted seems to import neatly into Excel (although I haven't checked any of it).

About

Avatar for Nef @Nef started