Count Unique Values in Spreadsheet

This document is in development

UNIQUE finds the unique values in a spreadsheet row or column.

COUNTA counts the results of UNIQUE, result returns a numeric value.

=COUNTA(UNIQUE(A1:B100))