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
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives