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.
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
@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.
Thanks for clarifying your question more clearly, this has been asked previously here