Count Order of Occurrence of Duplicates in Excel Using COUNTIF Function | Excelgraduate

Suppose, you have an item that appeared 3 times in your Excel sheet. Now you want to count their order of occurrences which is 1, 2, and 3. But how can we calculate this order of occurrences of the duplicate values in Excel?
Well, you'll get the answer in the video. This video tutorial will show you how to count the order of occurrence of duplicates in Excel using a formula. Here I've used the COUNTIF function to count the order of occurrence of the duplicates.

Chapters
0:00 Intro
0:45 Using COUNTIF Function to Count the Order of Occurrence of the Duplicates in Excel
2:33 Formula Explanation

Regards!

#excelgraduate
#countduplicatesinexcel