Count Unique Values in Spreadsheet

This document is in development

SEARCHUNIQUE finds "textthe value"unique values in cella A1.spreadsheet row or column.

IFCOUNTA resultcounts the results of SEARCHUNIQUE is that the data is found,, result returns TRUE.a Else,numeric FALSE.value.

=COUNTA(UNIQUE(A1:B100))