I have an Excel spreadsheet with two columns:
Col 1 = Department, Col 2 = Employee Name
I would like to count each time the same department appears for the employee and reset the count when a new department is listed.
I tried the
COUNTIF() function where it can count all of the departments for the user, but the counter does not reset.
Below is an example of my data; the green column shows the result I would like to achieve.