How to not count duplicate cells in excel

00:00excel trick how to count duplicates

00:02values in a column in excel

00:05if you have a list of data in a

00:07worksheet with unique values and

00:09duplicate values and you do not only

00:12want to count the frequency of duplicate

00:14values also want to know the order of

00:16the occurrence of the duplicate values

00:19in excel the countif function can help

00:22you count the duplicate values

00:24go to cell b4 by clicking on it

00:27formula is equal to countif dollar eight

00:30dollar for a4 a4

00:34press enter

00:38drag and down the formula from b4 to b24

00:44in this way we can count the duplicate

00:46entry

00:47thank you for watching