Count Unique Values In A Range

less than 1 minute read Link to all xlsx Example Files: 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 … Read more