G
Guest
Hi all,
I have a dozen of worksheets, in each worksheet I have a column that
contains an alpha code to convey statuses. For example, I can have a status
"R" fo ready, "C" for completed...etc.
Users of this workbook would go through each tab and every row and assign
status in the colum (say in column A) R, C or something else. But
sometimes, where there's no status, the users leave it blank (""). Other
times, a user error can cause a "" to become " " or any number of blank
spaces in the quote " ".
I need a way to count all cells in a given range in column A where their
statuses are not equal to "R" or "C". Since if the cell is not either one of
these, then user would know how many more rows needs t be updated with status
for all the worksheets in the workbook.
Is there a quick way of doing it? I can cycle through each tab and read row
by row and count them, but I thought there must be an Excel formula I can
take advantage of. Thanks in advance for sharing your thoughts.
Ben
--
I have a dozen of worksheets, in each worksheet I have a column that
contains an alpha code to convey statuses. For example, I can have a status
"R" fo ready, "C" for completed...etc.
Users of this workbook would go through each tab and every row and assign
status in the colum (say in column A) R, C or something else. But
sometimes, where there's no status, the users leave it blank (""). Other
times, a user error can cause a "" to become " " or any number of blank
spaces in the quote " ".
I need a way to count all cells in a given range in column A where their
statuses are not equal to "R" or "C". Since if the cell is not either one of
these, then user would know how many more rows needs t be updated with status
for all the worksheets in the workbook.
Is there a quick way of doing it? I can cycle through each tab and read row
by row and count them, but I thought there must be an Excel formula I can
take advantage of. Thanks in advance for sharing your thoughts.
Ben
--