Counting a Unique identifier in a column
Hello SS Community,
I am halfway there but seem to be doing something wrong I want to count how many times a Person shows up in the list and record the number.
I have this formula =IF(COUNTIF([Person Number]:[Person Number], [Person Number]@row) > 1, 1) and it is working perfectly to record when the person number in the Person number column shows up more than once but when I add the second layer to record two when the person number shows more than two =IF(COUNTIF([Person Number]:[Person Number], [Person Number]@row) > 1, 1) IF(COUNTIF([Person Number]:[Person Number], [Person Number]@row) > 2, 2)) It does not do anything and still records 1 even when the exact person number is in the column twice.
I also tried to use this formula =COUNTIF([Person Number]:[Person Number], [Person Number]@row) which worked but the reason I can't use this is I don't want to count the first occurrence of the person number in the sheet I am trying to use it to count how many times the person number was rescheduled, so the first occurrence should be removed from the count.
Best Answer

Try this, then:
=if(COUNTIF([Person Number]:[Person Number], [Person Number]@row)>1,COUNTIF([Person Number]:[Person Number], [Person Number]@row)1,"")
Really all you're doing is subtracting 1 from the count if it qualifies, but it should do the trick!
Answers

Hi @Omotola Ashafa,
Try this:
=if(COUNTIF([Person Number]:[Person Number], [Person Number]@row)>1,COUNTIF([Person Number]:[Person Number], [Person Number]@row),"")
This should only list the number of occurrences if there's more than one row with that person; otherwise, it will be blank.
Let me know if it works!
Best,
Heather

Thank You @Heather D ,
It works as you explained. The only thing is we would like the total rescheduled number only, so we want the first occurrence removed from the count.

Try this, then:
=if(COUNTIF([Person Number]:[Person Number], [Person Number]@row)>1,COUNTIF([Person Number]:[Person Number], [Person Number]@row)1,"")
Really all you're doing is subtracting 1 from the count if it qualifies, but it should do the trick!

It worked, thank you so much and thanks for explaining the formula too

@Omotola Ashafa You're welcome! I'm glad it worked.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!