![]() 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. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |