=LEN Function for counting semi colons

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.

daddylonglegs,

THANK YOU, worked perfect.

The funny part is I spent about four hours bouncing back and forth between sumproduct and Len, never thought to try and combine.

Me great with Power Point, no so much with Excel.

V/R Joe