0
0
Count Text without counting duplicates in Excel

Count Text without counting duplicates in Excel

January 8, 2021

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

Top rated

Products

Excel Man

About Us

Excel Man is a platform which is dedicated to teach people advanced usage of MS Excel & other similar products so that they can become an Expert in it and can enhance their working profile with the changing needs of today’s world.

Top rated products

11 Comments

erotik
reply
March 1, 2021 7:22 pm

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
reply
March 2, 2021 11:12 am

Thank you!!

php shell
reply
April 8, 2021 6:21 am

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.

EN iyi Leke Kremi
reply
May 6, 2021 1:32 am

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!!

Donnie
reply
August 28, 2021 4:23 pm

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.

Dian
reply
August 30, 2021 6:47 pm

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!

Camilla
reply
August 31, 2021 2:22 pm

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

Kurtis
reply
September 12, 2021 7:09 pm

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!

Jamal
reply
September 14, 2021 2:46 am

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!

Marangoz Atölyesi
reply
April 11, 2023 1:39 pm

quality and beautiful content

En Yakın Marangoz
reply
April 12, 2023 12:45 am

thanks for the content

Leave a Reply to EN iyi Leke Kremi Cancel reply