I'm a complete amateur when it comes to Excel so bear with me if my description isn't brilliant.
I have a table of results extracted from a database. The number of rows varies each week, say.
I use a COUNTA function on columnA (which is always populated) in order to find out how many rows the table has.
Then in subsequent columns, I want to count how many blank values I have. I tried doing this using the COUNTBLANK function, but I want to refer to the result of the COUNTA from columnA to define the range that this COUNTBLANK should consider.
Any advice gratefully received
Bookmarks