This is an array formula, so enter it with Ctrl+Shift+Enter

=SUMPRODUCT((A1:A100<"")/COUNTIF(A1:A100,A1:A100&""))

"DTTODGG" wrote:

Hello-

Is there a simple way to count the number of different entries in a column?

ex. I have multiple rows for the same "salesperson". I have many
salespersons. I want to know how many salespersons I have.

I guess I'm counting non-duplicate entries in a column.

Thank you,
I'm learning lots!