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

How to Count the Non Repeating Data in MS Excel

Date:2019-9-6 Author:Cordelia

Sometimes you want to count a long list of data in Excel, but there are many duplicates interfering with your statistics, and you can’t just delete them. At this point, is there a way to get rid of the influence of repeated data and count only the non-repeating data in a column?

As the answer to many other questions – the powerful Excel functions can help you. All you have to do is telling Excel the range of data you want to count, the criteria of counting, and of course, choosing a right formula.

How to Count the Non-repeating Data in a Column

1. If you want to count the data in column A, you can create a new column aside to assist.

How to Count the Non Repeating Data in MS Excel

2. Enter the formula in B2: =SUMPRODUCT(1/COUNTIF(A2:A11,A2:A11)). “A2:A11” refers to the range of cells you want to count, you can change it according to your actual situation.

How to Count the Non Repeating Data in MS Excel

3. Press [Enter] key to work the formula out, the number of unduplicated data will be counted accurately and displayed in B2.

How to Count the Non Repeating Data in MS Excel

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 *