Hi everyone,
I want to count blank cells in every third column in a worksheet.
Each row contains around 100 cells - the third of which is a drop-down indicating a status...open, closed, etc.
Ideally I want a counter at the start of each row - the rows represent a particular task - to indicate how many statuses have not yet been assigned.
Something more concise than a string of countblanks possibly…?
Any ideas appreciated.