Blogger Text

My Aim to Provide you quality contents, Tips & Tricks, Software, Microsoft Office, Graphic Editing (Adobe PhotoShop, After Affects, Illustrator, inDesign) Corel Draw, Corel Video Studio, Cyberlink PowerDirector, Power ActionCinema, Tutorials about Blogging and VU Assignments, Quizes & GDB Solutions and Much More... at regular Basis
                                     ***    Kindly Subscribe our Official YouTube Channel "INFOPALACESS OFFICIAL-Tuts: in this channel we upload Programming (C,C++,C# JAVA, PHP), Web Development, Graphics Editing and Microsoft Office Step by Step Tutorials from bigginer to Advance Level. We also provide free online courses at our YouTube Channel. ***   Graded Assignments/Quizes and GDB will start in Next Week. Solution ideas of All assignments, Quizes and GDB will be available here. If you have any problem regarding this then you can contact us.

How to Count Duplicate Values Only Once In any Column in Excel in few seconds?

Sometimes we have some duplicate values  in a column of our worksheet, and we need to count the same or duplicate values only once which means.

To Calculate duplicate values only once watch the video below for step by step guidance:

There are two Methods to complete this task;
1-         By Implementing Excel Formula
2-         By Using KU Tools

Here I am going to mention only first method.
To count duplicate values only once you need to add following formula.
into a blank cell where you want to output the result, and press Enter key to get the result, see Picture [1] below:

In the above formula, C5:C20 is the data range that you want to count the duplicates only once.

Post a Comment