less than 1 minute read
Link to all xlsx Example Files: https://github.com/ExcelTitan/Excel_Formulas
To count the unique values in a range place the following formula in B2, this is an array formula so remember to hit Ctrl+Shift+Enter This formula handles and ignores empty cells in the range as well
{=SUM(IF(FREQUENCY(IF(A2:A9"",MATCH(A2:A9,A2:A9,0)),ROW(A2:A9)-ROW(A2)+1),1))}
| Name |
|---|
| Beth |
| Nicole |
| Adam |
| Beth |
| Michele |
| Anthony |
| Beth |
| Hayley |
Tags: array-formulas, unique
Categories: formulas
Updated: September 25, 2018