Hello, I have a puzzle that I cannot solve,
I have the following formula to count the number of nonblank cells in a column
="Check Type "&COUNTIF($AA$2:$AA$7500,"<>")
The spreadsheet is refreshed daily and I use thefollowing code to clear out the dataprior to the refresh.
If...