Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How To Get Total Number Without Repetition?

Date:2021-10-23 Author:Sandra

I’ve got a list right now, and  I need to know how many people are on it.

I took a look and I knew there were 19 people, but I realized that there were a lot of names that were repeated.   So how do I quickly figure out the total number of people without repetition?

How To Get Total Number Without Repetition?

Well, there is a very easy way.

Just type =SUMPRODUCT(1/COUNTIF(A2:A20,A2:A20)) in cell E6, and press Enter key.

How To Get Total Number Without Repetition?

What if I want to know not only the number of people but also a list of no duplicate names? That’s easy too.

Just enter =INDEX($A$1:$A$20,MATCH(,COUNTIF(E$1:E1,A$2:A$20),)+1)&”” in cell E2,remember to press Ctrl, Shift and Enter keys together. Then use the fill handle. ( The small black square in the lower-right corner of the selection.)

How To Get Total Number Without Repetition?

There are a lot of ways to get data that doesn’t duplicate.  It’s just that everything we’ve done today has to do with the COUNTIF function.  Did you learn? 

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *