I need the formula to count how many clients are entered into my column.
For example, on my column B2, I am having the following list
I want my result to be updated on 3. because I am having three clients (Client A, Client B, Client C).
If I add one more client name like Client D then my result should update 4 automatically.
Can anyone help me with how to do this?