Count the # of unique items in a column, excluding blanks

Excel Formula to count the # of unique items in a column, excluding blanks

 

=SUMPRODUCT((B21:B1421<>"")*(1/COUNTIF(B21:B1421,B21:B1421 &"")))