Counting Unique Occurrences in an Excel Spreadsheet
Monday, January 28th, 2008 21 viewsThis 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 ...
