Count how many time the same value appears in a row without defining value in the function


I am building a sheet where we log car registration number / car number plate. Let's say there are 3 column for Date, Time and Rego number. I want to make another column that shows how many time the same Rego number has been logged in the sheet without defining the value of what the function is looking for but rather just grab the value from Cell X and check through Column X

Best Answer