I’m trying to retain an count.
My spreadsheet is designed to count the cells labelled “Enquired” and then count. But during my process, cells are changed to other values but I would like to retain the original count automatically.
For example, I will use data vailidatio to label several cells as “Enquired”, and at this point i would like the cells labelled this to be counted. I will then in future use the data validation to change these cells to other words. But then the count will drop. How do i keep that original count?