Count Text without counting duplicates in Excel

Hi Guys,

A lot of people has asked me this query on How to Count Text without counting duplicates in Excel, so I have decided to write an article on it, so let us discuss first what the query is, so we all know very well how to count text in Excel, for this we have COUNTA FUNCTION

Now lets assume a situation where you wants to COUNT text but with the condition that any duplicates coming in the range will be excluded, so the way to do that is discussed in this article, so lets learn

In the given situation, you can see that we have a lot of rows containing text, though duplicates are coming in these lines

Now, If I apply COUNTA (=COUNTA(D5:D20)) in it you can see that the result is 16

However, we want that excel should count only unique values in it, so how to do it

The answer is hidden in the question itself, as you only have to use UNIQUE Function in it & type instead of =COUNTA(D5:D20), =COUNTA(UNIQUE(D5:D20)), then we will get the result as 4, which is what we require