Hello, i am after a formula that will allow me to count how many cells in a row contain the same value. Basically i am wanting to make an attendance streak calculator for my classroom. This will allow me to see how many days in a row each student has been in school. Any AI response is not making...