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
-
Are you looking for something like this?
If so, you can use the COUNTIF function.
=COUNTIF([Rego Number]:[Rego Number], [Rego Number]@row)
Answers
-
Are you looking for something like this?
If so, you can use the COUNTIF function.
=COUNTIF([Rego Number]:[Rego Number], [Rego Number]@row)
-
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 !
-
Glad I could help! 😁
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives