I am stuck on what I thought would be the "easy" part of a project - got through all the VBA/SQL lookup part.
What I need to do if have a countif function setup that looks for a specific text string ("Yes") in one column and only counts based on that - Done
It also needs to reset to an output of "1" for any variable if the value of column A (date in this case) changes. - Hopelessly Stuck
Here is what I have, and is working perfectly except for resetting on a new day:
Attached is a sample of the data I am looking at. The lines in yellow need column O to reset to 1 since the date in column A has changed.