Hi Guys,
I am not sure if could still add my response since this post says ...[SOLVED], anyhow, my approach to tackle Erin's question would be to write a small UDF like this.
Function UniqueCount(R As Range) As Long
Dim Ar
Dim Rng
Rng = R
If Right(Rng, 1) = ";" Then
Rng = Left(Rng...