Hello,
I have the following set of data (see attached file). Basically I have expenses for the past 6 years.
Now, I would like to define a dynamic range that takes into account only the last 6 quarters. So, if I write Q2 2016 in cell A4 for instance, the range should automatically be set as...
Hello,
I am using an Excel table to track action items decided in meetings. For instance, I will have an action like "Paul needs to talk to Roger" in A1, then in B1, I have the date this is supposed to happen, say "3/1/2017", and in C1 I have used conditional formatting/gradient fill to track...