Forum Discussion
kirvis
Helper I
Helper IAdd column that restarts counting for each new category
Hi all, I am trying to add a number column that restarts counting every time a new category starts. Example: Cat CustomColumn A 1 A 2 A 3 B 1 B 2 B 3 C ...
Hi,
you can achieve this with the grouping function and then index it.
A nice Article about it is her.
https://www.excelguru.ca/blog/2018/06/27/number-rows-by-group-using-power-query/
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!
rainer1
Resolver III
Resolver IIIHi,
you can achieve this with the grouping function and then index it.
A nice Article about it is her.
https://www.excelguru.ca/blog/2018/06/27/number-rows-by-group-using-power-query/
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!
kirvisHelper I
Helper IAh yes, excellent! That is exactly what I needed!
Thanks!
Thanks!