Counting repeated values in a Column
Good afternoon,
Looking for a function that counts the number of times a value appears in a colunm and returns the number of that particular repetion as a number. see example below
Many thanks in adavance fo the support.
Best regards,
Marco
Best Answer
-
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.
0 -
Hi Marco
Thanks for clarifying your question more clearly, this has been asked previously here
0
