1. B

    Why is this not counting using the countifs?

    I have a large amount of raw data and have a graph to help visualize the important info. I made a couple tables to fill the charts but one of my countifs isn't working. This is my formula =COUNTIFS(Data!B2:B,"=Doug Harrison",Data!A2:A,TODAY()) but it always returns 0. B2:B is where the names...
  2. Q

    Find Last Row counting from the 2nd row down?

    I want to delete all the cells from Row 2 down for column 1 and 2. What is the best way to do it? I tried this but the lastRow is simply the last row number which does not help because I would delete the first row too. I need something like offset...what's the best way? lastRow =...

Some videos you may like

This Week's Hot Topics