I am trying to calculate a YEAR_ID by concatenating my current row’s YEAR with a count of how many of those years are in the table, +1 to add to the count.
So if I add 5 rows, and the first 2 are 2017, and the next and 3 are 2018, the Year_ID’s would be 2017_1, 2017_2, 2018_1, 2018_2, and 2018_3.
I just don’t understand how to write the select, list, and count.
=CONCATENATE(TEXT([Year]),"_",(COUNT(SELECT(LIST([Year]…???))+1)
Any help greatly appreciated.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |