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))
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))