hi guys i have this code here that steve gave on my last post but i’m trying to solve it it’s only adding up to the first record and not the last
CONCATENATE(
RIGHT(
CONCATENATE(
"0000",
(
NUMBER(
ANY(
TOP(
SORT(
SPLIT(
SUBSTITUTE(
CONCATENATE(
SELECT(
table[column],
ENDSWITH([column], ("/" & YEAR(TODAY())))
)
),
("/" & YEAR(TODAY())),
""
),
" , "
),
TRUE
),
1
)
+ LIST("-1")
- LIST("")
)
)
+ 1
)
),
4
),
("/" & YEAR(TODAY()))
)
can @Steve or someone else save me
User | Count |
---|---|
42 | |
25 | |
24 | |
19 | |
15 |