Counting repeated values in a Column
Best Answer
-
Mirjam Schuke Administrator
Hi Marco,
You can use the group step in a workflow and then choose for which columns you would like to count the values. A Function looks at each individual value in a column(s) independently, whereas a Workflow step looks at a column or table as a whole.
You can find more information here
1
Answers
@Mirjam Schuke Thanks for the response.
your process will give me the total number of times that the value is repetead. However, what I need is to number the repetition itself i.e. the first repetition of A is number 1 the second receives 2 and so on for any value that is repetead in the analysed column.
Hi Marco
Thanks for clarifying your question more clearly, this has been asked previously here