Good Day,

I am responsible for creating evaluations for my employees. They do input their daily work into a database that I am able to extract into an excel spreadsheet.

The formula below works great for counting within a single cell, the clients they interact with, but I would like to know how to count a full column. The counting of the unique values would be a plus, but not required.



Len(a1)-len(substitute(a1,";",""))+1

Thank you,

R/ Joe, US Navy retired.