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

Count Text without counting duplicates in Excel

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

11 comment on “Count Text without counting duplicates in Excel”

  • Anshuman Tandon March 1, 2021

    My relatives every time say that I am killing my time here at net, however I know I am getting knowledge everyday by reading such pleasant posts. Elle Lyman Marinna

    • Anshuman Tandon March 2, 2021

      Thank you!!

  • Anshuman Tandon April 8, 2021

    Hey There. I found your blog using msn. That is a really neatly written article.
    I will make sure to bookmark it and return to read more of
    your helpful info. Thank you for the post.
    I’ll definitely comeback.

  • Anshuman Tandon May 6, 2021

    Oh my goodness! Amazing article dude! Thanks, However I am going through issues with your RSS.
    I don’t understand the reason why I am unable to
    join it. Is there anyone else having the same RSS problems?

    Anyone who knows the solution can you kindly respond? Thanx!!

  • Anshuman Tandon August 28, 2021

    We stumbled over here from a different web address and thought I might check things out.
    I like what I see so now i am following you. Look forward to looking into your web page yet again.

  • Anshuman Tandon August 30, 2021

    This design is spectacular! You certainly know
    how to keep a reader amused. Between your wit and your videos, I was almost
    moved to start my own blog (well, almost…HaHa!) Wonderful job.
    I really enjoyed what you had to say, and more than that, how you presented it.
    Too cool!

  • Anshuman Tandon August 31, 2021

    Magnificent beat ! I wish to apprentice while you amend your website, how could
    i subscribe for a blog web site? The account helped me a acceptable
    deal. I had been a little bit acquainted of this your broadcast offered bright clear idea

  • Anshuman Tandon September 12, 2021

    You actually make it seem so easy together with your presentation but I find this topic to be really
    something that I think I might by no means understand. It
    kind of feels too complicated and extremely huge for me.
    I am taking a look forward in your next publish, I’ll attempt to get the grasp of it!

  • Anshuman Tandon September 14, 2021

    Have you ever considered about adding a little bit more than just your
    articles? I mean, what you say is important and all.
    However just imagine if you added some great graphics or video clips to give your posts more, “pop”!
    Your content is excellent but with images and clips, this website could undeniably be
    one of the very best in its niche. Awesome blog!

  • Anshuman Tandon April 11, 2023

    quality and beautiful content

  • Anshuman Tandon April 12, 2023

    thanks for the content

Write a comment