This is the Formula tag.

Excel icon

Counting Unique Occurrences in an Excel Spreadsheet

This formula, entered as an array (Ctrl+Shift+Enter) in a single cell, will show you if there any duplicate entries in a given range (in this case, A1:C100). It is wrapped in an IF function to provide a friendly message; a kind of in-cell error handling, if you will. I usually do this when I know others are going to use the formula, to make it easy for them to understand the output. Otherwise it just gives you the number of unique entries which some people may not know what to do with.

Continue Reading »

learn excel dashboards