I am working on attendance records - see below.
I have a column at the end that needs to count the successive 'N' attendance in a row (start counting at 1 for first recording of it) and then continue counting for each successive 'N' in that row. But then the counting needs to restart when a Y is entered in the row.
I can remove the Mode and Yearly Unattend columns if it makes the formula more practical.
Any suggestions for a formula?
I have a column at the end that needs to count the successive 'N' attendance in a row (start counting at 1 for first recording of it) and then continue counting for each successive 'N' in that row. But then the counting needs to restart when a Y is entered in the row.
I can remove the Mode and Yearly Unattend columns if it makes the formula more practical.
Any suggestions for a formula?