All,
I have the Excel Table, that I want it to generate a unique ID for each new row.
However I have 2 types of entries in the spreadsheet CR= "Change Request" EW = "Early Warning" (Project Management Terms).
This will be a drop down selection in Column A
Column B - Here I want to work out what was chosen in Column A and then add the next sequential number for either CR or EW
So image of below is what I would like to achieve.
snip.png
Formula:
Please Login or Register to view this content.
Rio,
Thanks for that, however as more entries are added all the existing rows also increase in number, so they all grow to say CR4 or EW4. (Because im in a excel table and each line added counts the column and not individual cell reference)
Last edited by hsduk101; 11-25-2020 at 09:19 AM.
I don't think you have copied the formula correctly!
Please double-check what you were given for B2, and then drag copy it down:
=A2&COUNTIF($A$2:A2,A2)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Entered in correctly, However this is what is happening.
snip2.png
As the table increases, the previous lines dynamically increment also. See formula in forumla bar and how the line above last has changed its range to A9 also
No, not entered correctly (two green triangles are a give away). If you had entered the formula correctly in B2 and drag copied down, that cell would show this:
=A8&COUNTIF($A$2:A8,A8)
and not this:
=A8&COUNTIF($A$2:A9,A8)
See the difference? User error, I am afraid - sorry.
Last edited by AliGW; 11-25-2020 at 10:15 AM.
If you want the formula to fill down automatically, you'll need to use this in B2:
=[@Change Request Type]&COUNTIF($A$2:[@Change Request Type],[@Change Request Type])
Last edited by AliGW; 11-25-2020 at 10:15 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks