Count if function and sequential numbering
I have been banging my head trying to get this to work. I am trying to get an auto number that goes 1-….., for each name that appears in another row. Ex. Jim shows up 5 times this each time would be numbered 1-5, then Jordan shows up 8 times and would be numbered 1-8. So on and so forth. Any help would be appreciated.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Best Answers
-
I actually figured it out after just building the countifs one condition at a time.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
I just noticed I did not post my answer. The formula I wound up using was
=COUNTIFS(Date:Date, >Date@row, UT:UT, <>"", ID :ID, =ID@row)
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Answers
-
Hi @Mark.poole,
In your example, are you saying you want to see "1 - 5" for every instance of Jim or "1 - 5", "2 - 5", "3 - 5", "4 - 5", "5 -5"?
If it is the former, which it seems to be, use this: ="1 - " + COUNTIF(Name:Name, Name@row)
Hope this helps,
Dave
-
Actually after further researching what it is I need. Im Wanting to return an incremental value. So if jim appears 5 times each row JIM appears in would be numbered 1-5. I have a formula that achieves this. how ever due to formula cell reference restraints I had to create a work flow to copy data to another sheet. So I would need the incremental numbers to start with the current most recent date.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
I actually figured it out after just building the countifs one condition at a time.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
I just noticed I did not post my answer. The formula I wound up using was
=COUNTIFS(Date:Date, >Date@row, UT:UT, <>"", ID :ID, =ID@row)
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!