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

NedOnSmartsheet

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

jmyzk_cloudsmart_jp

Hi @NedOnSmartsheet

Are you looking for something like this?

If so, you can use the COUNTIF function.

=COUNTIF([Rego Number]:[Rego Number], [Rego Number]@row)

https://app.smartsheet.com/b/publish?EQBCT=aa9a07fd3d714447a802232d1ea7606f

jmyzk_cloudsmart_jp

Hi @NedOnSmartsheet

Are you looking for something like this?

If so, you can use the COUNTIF function.

=COUNTIF([Rego Number]:[Rego Number], [Rego Number]@row)

https://app.smartsheet.com/b/publish?EQBCT=aa9a07fd3d714447a802232d1ea7606f

NedOnSmartsheet

https://community.smartsheet.com/discussion/comment/444437#Comment_444437

Yes ! now I see where I have gone wrong. I used the same function before, following others' example but I had all the of as @row so it did not work. Thank you !

jmyzk_cloudsmart_jp

Glad I could help! 😁