Counting value occurrences across multiple dynamic columns

[Processcreator]

Hi All,

Appreciate any assistance in advanced.

I am trying to determine how to count the number of times a name occurs across multiple columns. The columns will differ in length which will change over time. In my excel example below you will see that there are names in columns A B C and the count column has two names. What I would like to do is count the number of times each name in the count column occurs in columns A B or C.

So in this case, would like a 2 for Mike and 1 for John.

I assume there is some sort of function that could be put in the formula tool but I can't seem to find a viable solution.

Thanks!

[jarrod · Accepted solution]

Transpose tool will solve this. Let me spin up an example.

Edit: I've attached the workflow.

Input

[Processcreator]

Much appreciated!