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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!