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!
Solved! Go to Solution.
Much appreciated!