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

Excel Count Unique Values


Revision #4
Created 30 October 2024 14:20:51 by B.B.B.Ben E. N. Agents
Updated 30 October 2024 14:26:35 by B.B.B.Ben E. N. Agents