On the attached spreadsheet, I am trying to count (in cell B2) the cells in each columnthat match the reference in column A. (in this example, there are two entries for Actongate)
I would like the column range to be dynamic and equal the column heading specified in cell A1 i.e. I would like to be able to change the date in cell A1 and the count range in the formula automatically adapts and returns the column count from the specified date.
Hopefully that's clear but please let me know if not and thanks in advance
Bookmarks