In this example the formula will return 3. In A2 we find the name Robert, so if we want to find out how many times Robert appears in the list, we can use this formula: =COUNTIF($A$2:$A$28,A2). In my example below I have 27 rows of data, with names in the range A2 to A28. two, three or four occurrences of the same piece of data, we need another approach: Conditional Formatting with a formula.įirst, let’s find out how to count the number of occurences in a list. But sometimes we want to make it more dynamic: If we want to be able to choose between highlightning duplicates, triplicates or quadruplicates, i.e. If you only want to locate duplicates, the super-easy way above is the right way to do it. Select the cells you want to check, go to the Home Ribbon, choose Conditional Formatting and select Highlight Cell Rules > Duplicate Values.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |