formula to add one to previous dependent on another column
Hi all, I know my subject is a little convoluted sounding, but I'm thinking this must be something fairly simple to do and I'm just not knowledgeable enough to know how... I have attached an example of my data. I would like to write a formula for my "Daynight consecutive" column to have it populate the field with a unique number according to the date (in the "date" column) and whether it is day or...