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 15, then Jordan shows up 8 times and would be numbered 18. So on and so forth. Any help would be appreciated.
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 15. 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.

I actually figured it out after just building the countifs one condition at a time.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!